How to Insert Bullet Points in Excel? 6 Multiple Ways

Bullet points help structure and organize data clearly, making spreadsheets easier to read. Since Excel doesn’t have a built-in bullet point feature like Microsoft Word, you need to use alternative methods. excel bullet points.

1. Using ALT Key Shortcuts

A quick way to insert bullet points is by using the ALT key:

• Click on a cell where you want the bullet.
• Press ALT + 7 (•) or ALT + 9 (◘) on the numeric keypad.
• Press Enter to save the bullet.

2. Using the CHAR Function

The CHAR function helps you insert symbols in Excel, including bullet points:

• Type =CHAR(149) in a cell and press Enter to insert a bullet (•).
• To add text, use: =CHAR(149) & " Task A".

3. Using Custom Number Formatting

To apply bullets automatically in multiple cells:

• Select the target cells.
• Press CTRL + 1 to open Format Cells.
• Go to Number > Custom, enter • @, and click OK.
• Now, every text entered in the selected cells will start with a bullet.

4. Using the Symbol Tool

The Symbol tool allows you to insert bullets manually:

• Click inside a cell, then go to Insert > Symbol.
• Select Arial Unicode MS, find the bullet (•), and click Insert.

5. Copy-Pasting a Bullet Point

• Copy a bullet point from another source, such as Word.
• Paste it into an Excel cell and add your text after the bullet.

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

To insert multiple bullet points within a single cell:

• Use the formula:
• sql
• CopyEdit
• =CHAR(149)&" Item 1"&CHAR(10)&CHAR(149)&" Item 2"
• Enable Wrap Text to display the bullets properly.

Conclusion

These six methods allow you to insert bullet points in Excel effectively, improving the structure and readability of your spreadsheet.