Site icon Professor Excel

Bullet Points in Excel: 6 Easy Methods (+Download)

bullet, points, excel

Bullet Points in Excel

No matter if you use Microsoft Word, PowerPoint, Outlook or OneNote: You can easily insert bullet points and create bullet point lists. In Excel you can’t. But there are some simple workarounds. In this article, you learn 6 methods for inserting bullet points in Excel. 


Like said in the introduction, there is no very smooth way to create bullet point lists in Excel. Either the methods require several steps or the result just doesn’t look very nice. In this article, you learn 6 methods of inserting bullets in Excel – either directly into the Excel cell or to a text box. In the summary section of this article, you can download all 6 methods in a comprehensive Excel workbook.

Method 1: Alt + 7, Alt + 9 or Alt + 0149

Insert the bullet symbol with the keyboard shortcut Alt + 7 (on the number pad).

The first method is usually also the fastest: Insert the bullet symbol with a keyboard shortcut. In order to achieve this, enter a cell (for example by pressing F2 on the keyboard) and press Alt + 7 on the number pad.

Please note:

Method 2: Insert the bullet symbol from “Symbols”

Insert a bullet character from the “Symbol” feature in Excel.

The second method is quite similar to our first method above. But instead of using a keyboard shortcut, you manually insert the bullet character.

  1. Click on “Symbol” on the right-hand side of the “Insert” ribbon.
  2. Select the character you’d like to use as the bullet symbol.
  3. Press Insert.

Please note:

Do you want to boost your productivity in Excel?

Get the Professor Excel ribbon!

Add more than 120 great features to Excel!

Method 3: Copy and paste the bullet point character (from here)

This method is again very similar to methods 1 and 2 above. Instead of inserting the character with a keyboard shortcut or from the “Symbol” menu, you could just copy and paste it from there. Please feel free to copy any of the characters below.

• ● ◦ ▪ □ ♥ ─ − → ►

Method 4: Use a custom number format

Use a custom number format in order to create a bullet point list.

If you don’t want to insert the bullet character for every cell again you could just define a custom number format which adds the bullet character automatically.

Please note:

Method 5: Add an additional column

Use an additional column for inserting bullet points.

The fifth method for inserting bullet points usually looks most tidy. The idea is to insert an additional column containing the bullets. Please take a look at the example on the right-hand side.

Please note:

Method 6: Bullets in text boxes and charts

You can add bullets to text boxes in Excel easily.

If you don’t want to add bullet points inside an Excel cell but to a text box in Excel instead, you can use the built-in function.

  1. Insert a text box either into your chart or the worksheet itself. In order to achieve this, click on “Insert” and then “Shapes”. Select the text box and draw it onto the screen.
  2. Right click into the new text box.
  3. Click on “Bullets”. If you want to change the type of bullets, click on the small right arrow.

That’s it. Now you can start typing your text.

Summary of bullet points in Excel

In this article, you learn how to insert bullets to text cells and text boxes in Excel. The first 4 methods introduced above insert the bullet symbol into your Excel cell. Method 5 uses an additional column which has the advantage, the multi-line cells have a nice line break. The sixth method deals with bullets in text boxes.

 Method 1Method 2Method 3Method 4Method 5Method 6
NameAlt + 7, Alt + 9 or Alt + 0149Insert the bullet symbol from “Symbols”Copy and paste the bullet character (from here)Use a custom number formatAdd an additional columnBullet points in text boxes and charts
DescriptionInsert the bullet symbolInsert the bullet symbolInsert the bullet symbolInsert the bullet symbolUse a helper column for the bullet symbolInsert a text box and right click into it. Then click on “Bullets”
Works on multi-line cellsNoNoNoNoYesYes

Please feel free to download the example workbook here. It contains 6 detail worksheets (for each method one worksheet) plus the summary table.

Was this page useful for you?

Image by Pezibear from Pixabay

Exit mobile version