How to Insert Bullet Points in Excel? 6 Multiple Ways
Adding bullet points in Excel helps organize data more clearly. Since Excel does not have a built-in bullet function like Microsoft Word, you can use alternative methods to excel bullet points. Below are six different ways to do it.
1. Using ALT Key Shortcuts
A simple way to insert bullet points is by using the ALT key:
Click on a cell where you want the bullet point.
Press ALT + 7 (•) or ALT + 9 (◘) on the numeric keypad.
Press Enter to save the bullet in the cell.
2. Using the CHAR Function
The CHAR function allows you to insert special characters:
Type
=CHAR(149)in a cell and press Enter to display a bullet (•).Combine the bullet with text:
=CHAR(149) & " Task A".
3. Using Custom Number Formatting
To add bullet points automatically to multiple cells:
Select the cells where you want bullets.
Press CTRL + 1 to open Format Cells.
Go to Number > Custom, type
• @, and click OK.Now, any text you type in the selected cells will start with a bullet.
4. Using the Symbol Tool
The Symbol tool allows you to insert bullets manually:
Click on a cell and go to Insert > Symbol.
Select Arial Unicode MS and find the bullet symbol (•).
Click Insert, then Close.
5. Copy-Pasting a Bullet Point
If you have a bullet point from another source (like Word):
Copy the bullet and paste it into an Excel cell.
Double-click the cell to add text alongside the bullet.
6. Using a Formula for Multiple Bullet Points in One Cell
To insert multiple bullet points in a single cell:
Use the formula:
sqlCopyEdit=CHAR(149)&" Item 1"&CHAR(10)&CHAR(149)&" Item 2"Enable Wrap Text from the Format menu for proper display.
Conclusion
These six methods allow you to add bullet points in Excel efficiently, making your data more structured and readable.