How To Create Bullets In Excel?

Select the cell where you want the bullet

Press Alt+7 on the numeric keypad to insert a bullet

Press Alt+0149 on the numeric keypad to insert a bullet

Use Insert > Symbol and choose a bullet character

Copy and paste a bullet from another source

Use the formula `=CHAR(149)&” your text”` for a bullet in a cell

Use `=UNICHAR(8226)&” your text”` in newer Excel versions

Add bullets within a cell by pressing Alt+Enter for a new line and repeating the bullet character

Use a text box if you want more flexible bullet formatting

Use the Bullet and Numbering options in Word, then paste into Excel if needed

Suggested for You

Trending Today