How to Insert Bullet Points in Excel? 6 Multiple Ways

Bullet points in Excel improve data presentation and readability. Since Excel does not offer a built-in bullet point feature like Microsoft Word, users must rely on alternative methods. how to add bullet points in excel.

1. Using ALT Key Shortcuts

The quickest way to insert a bullet point is by using an ALT code:

• Click on the desired cell.

• Press ALT + 7 (•) or ALT + 9 (◘) using the numeric keypad.

• Press Enter to confirm.

2. Using the CHAR Function

Excel’s CHAR function allows you to insert bullet points dynamically:

• Enter =CHAR(149) in a cell and press Enter to insert a bullet (•).

• To include text, type: =CHAR(149) & " Task A".

3. Using Custom Number Formatting

To apply bullets automatically to multiple cells:

• Select the cells you want to format.

• Press CTRL + 1 to open Format Cells.

• Go to Number > Custom, type • @, and click OK.

• Now, every entry in those cells will start with a bullet.

4. Using the Symbol Tool

For manual insertion, the Symbol tool is useful:

• Click inside a cell, then go to Insert > Symbol.

• Select Arial Unicode MS, locate the bullet symbol (•), and click Insert.

• Click Close to finish.

5. Copy-Pasting a Bullet Point

• Copy a bullet from another source (such as Word).

• Paste it into an Excel cell and type your text after the bullet.

6. Using a Formula for Multiple Bullet Points in One Cell

To list multiple bullet points within a single cell:

• Use this formula:

  sql
  =CHAR(149)&" Task 1"&CHAR(10)&CHAR(149)&" Task 2"
  

• Enable Wrap Text from the Format menu to ensure proper formatting.

Conclusion

These six methods allow you to insert bullet points in Excel efficiently, helping you present your data clearly and professionally.