8 ways to add bullet points in Excel

The tutorial shows a few simple ways to insert bullet in Excel. We will also share some tips on how to quickly copy bullets to other cells and make your custom bulleted lists.

Microsoft Excel is primarily about numbers. But it is also used to work with text data such as to-do lists, bulletin boards, workflows, and the like. In this case presenting information in a right way is really important. And the best you can do to make your lists or steps easier to read is to use bullet points.

The bad news is Excel does not provide a built-in feature for bulleted lists like most word processors including Microsoft Word do. But that doesn't mean there is no way to insert bullet points in Excel. In fact, there are at least 8 different ways, and this tutorial covers them all!

How to insert bullet points in Excel using keyboard shortcuts

The quickest way to put a bullet symbol into a cell is this: select the cell and press one of the following combinations using the numeric keypad on your keyboard.

Alt + 7 or Alt + 0149 to insert a solid bullet.

Alt + 9 to insert an empty bullet.

Apart from these standard bullets, you can also do some fancy bullet points in Excel like these ones: Insert bullet points using keyboard shortcuts

Once a bullet symbol is inserted into a cell, you can drag the fill handle to copy it to adjacent cells: Copy a bullet point to adjacent cells.

To repeat bullet points in non-adjacent cells, select a cell with the bullet symbol and press Ctrl + C to copy it, then select another cell(s) where you want to have the bullets and press Ctrl + V to paste the copied symbol. Copying a bullet point to non-contiguous cells

To add multiple bullet points to the same cell, insert the first bullet, hit Alt + Enter to make a line break, and then press one of the above key combinations again to insert a second bullet. As the result, you will have the entire bullet list in a single cell like shown in the screenshot below: Adding multiple bullet points to the same cell

Tips and notes:

  • If you are using a laptop that does not have a number pad, you can turn on Num Lock to emulate a numeric keypad. On most laptops, this can be done by pressing Shift + Num Lock or Fn + Num Lock.
  • To add a bullet symbol to a cell that already contains text, double-click the cell to enter the Edit mode, place the cursor where you want to insert the bullet, and then press Alt + 7 or Alt + 9.
  • In case you need to conditionally format your bulleted list or apply some formulas to it, say to count specific list items, it is easier to do if the items are normal text entries. In this case, you can put bullets in a separate column, align them right, and remove the border between the two columns.

How to add bullet points in Excel using Symbol menu

If you don't have a number pad or forget a key combination, here's another quick easy way to insert bullet in Excel:

  1. Select a cell where you want to add a bullet point.
  2. On the Insert tab, in the Symbols group, click Symbol. Opening the Symbol menu in Excel
  3. Optionally, select the font of your choosing in the Font box. Or, go with the default (normal text) option.
  4. Select the symbol you'd like to use for your bulleted list and click Insert.
  5. Close the Symbol dialog box. Done!
Adding bullet points in Excel using the Symbol menu

If you have difficulties finding a bullet icon among other symbols, type one of the following codes in the Character code box:

Bullet Symbol Code
2022
25CF
25E6
25CB
25CC

For example, that's how you can quickly find and insert a small filled bullet point: Find and insert a bullet symbol by its character code.

Tip. If you'd like to insert a few bullets into the same cell, the fastest way is this: select the desired symbol, and click the Insert button several times. Put the cursor between the first and second symbols and hit Alt + Enter to move the second bullet to a new line. Then do the same for the subsequent bullets: Move a bullet point to a new line.

Copy a bulleted list from Word

In case you have already created a bulleted list in Microsoft Word or another word processer program, you can easily transfer it to Excel from there.

Simply, select your bulleted list in Word and press Ctrl + C to copy it. Then, do one of the following:

  • To insert the entire list into one cell, double-click the cell, and press Ctrl + V.
  • To put list items into separate cells, click the cell where you want the first item to appear and press Ctrl + V.
Copy a bulleted list from Word.

How to do bullet points in Excel using formulas

In situations when you want to insert bullets into multiple cells at a time, the CHAR function may prove helpful. It can return a specific character based on the character set used by your computer. On Windows, the character code for a filled round bullet is 149, so the formula goes as follows:

=CHAR(149)

To add bullets to multiple cells in one go, perform these steps:

  1. Select all the cells where you want to put bullet points.
  2. Type this formula in the formula bar: =CHAR(149)
  3. Press Ctrl + Enter to insert the formula into all the selected cells. Add bullets to several cells at a time by using the CHAR function.

This method comes in especially handy when you already have some items in another column and you want to quickly create a bulleted list with those items. To have it done, concatenate a bullet symbol, space character, and cell value.

With the first item in A2, the formula for B2 takes the following shape:

=CHAR(149)&" "&A2

Now, drag the formula up to the last cell with data, and your bulleted list is ready: Create a bulleted list based on items in another column.

Tip. If you'd rather have your bulleted list as values, not formulas, fixing this is a matter of seconds: select the bulleted items (formula cells), press Ctrl + C to copy them, right-click the selected cells, and then click Paste Special > Values.

How to put bullet points in Excel using special fonts

In Microsoft Excel, there are a couple of fonts with nice bullet symbols, e.g. Wingdings and Webdings. But the real beauty of this method is that it lets you type a bullet character straight into a cell. Here's what you do:

  1. Select the cell where you want to put a bullet point.
  2. On the Home tab, in the Font group, change font to Wingdings.
  3. Type a small "l" letter to insert a filled circle bullet (●) or "n" to add a square bullet point (■) or some other letter shown in the screenshot below: Insert bullet points using special fonts.

You can insert even more bullet symbols by using the CHAR function. The point is that standard keyboards have only around 100 keys while every font set has 256 characters, meaning more than half of those characters cannot be entered directly from a keyboard.

Please remember, to make the bullet points shown in the image below, the font of the formula cells should be set to Wingdings: Insert bullet symbols by using the CHAR function.

Create a custom format for bullet points

If you want to spare the trouble of inserting bullet symbols into every cell over and over again, make a custom number format that will insert bullet points in Excel automatically.

Select a cell or a range of cells where you want to add bullets, and do the following:

  1. Press Ctrl + 1 or right-click the selected cells and choose Format Cells… from the context menu.
  2. On the Number tab, under Category, select Custom.
  3. In the Type box, enter one of the following codes without quotation marks:
    • "● @" (solid bullets) - press Alt + 7 on the numeric keypad, type a space, and then type @ as a text placeholder.
    • "○ @" (unfilled bullets) - press Alt + 9 on the numeric keypad, enter a space, and type the @ character.
  4. Click OK. Creating a custom format for bullet points.

And now, whenever you want to add bullet points in Excel, select the target cells, open the Format Cells dialog, select the custom number format we've just created, and click OK to apply it to the selected cells. You can also copy this format in the usual way using Excel's Format Painter.

Insert bullet points in a text box

If you don't mind using text boxes in your worksheets, then you'll have a more straightforward way to inset bullets in Excel. Here's how:

  1. Go to the Insert tab, Text group, and click the Text Box button: Insert a text box in Excel.
  2. In the worksheet, click where you want to have the text box and drag it to the desired size.

    Tip. For the text box to look tidier, hold the Alt key when dragging to align the edges of the text box with the cell borders.

  3. Type the list items in the text box.
  4. Select the lines you want to turn into bullet points, right-click on them, and then click the little arrow next to Bullets: Insert bullet points in a text box.
  5. Now, you can take your pick of any of the redefined bullet points. As you scroll over different bullet types, Excel will show a preview in the text box. You can also create your own bullet type by clicking Bullets and Numbering… > Customize.

For this example, I have selected Filled Square Bullets, and there we have it - our own bulleted list in Excel: A bulleted list in a text box in Excel

How to make bullet points in Excel using SmartArt

The best part is saved for the last :) If you are looking for something more creative and elaborate, use the SmartArt feature available in Excel 2007, 2010, 2013 and 2016.

  1. Go to the Insert tab > Illustrations group and click on SmartArt. Adding a SmartArt graphic in Excel
  2. Under Categories, select List, click the graphic you'd like to add, and click OK. For this example, we are going to use Vertical Bullet List. Inserting the SmartArt vertical bullet list
  3. With the SmartArt graphic selected, type your list items on the text pane, and Excel will add bullets automatically as you type: Type text for the bulleted list.
  4. When finished, switch to the SmartArt Tools tabs and craft your bullet list by playing around with colors, layouts, shape and text effects, etc.

To give you some ideas, here are the options I used to embellish my Excel bulleted list a bit further: Customizing the SmartArt bullet list

These are the methods I know to insert bullet points in Excel. If someone knows a better technique, please do share in comments. I thank you for reading and hope to see you on our blog next week!

38 comments

  1. None of the shortcuts ( Alt + 7 , Alt + 0149 or Alt + 9) work for me.

    • Use the numerical keypad on the right of the keyboard. The number keys above the letters do not work.

  2. Thank you

  3. This was so helpful, thank you

  4. Thanks a lot!

  5. I want to add an actual "#" symbol...hashtag, pound sign, octothorpe, etc...before a number. I've tried many variations of "''#''" but nothing has worked. Ideas?

  6. Great help. Thank you.

  7. thank you for this
    I have always copied from Excel to word, inserted bullets and then copied back to Excel
    I have now added the custom format "•@" to my custom format list and already started using it.

  8. Thank u a lot.
    May i know how to make bullet in one cell without alt+enter, because it need to do that much time that i want to make bullet point. i want to do this like as word.
    Is it possible?

  9. I forgot to add that I saved the macro to the personal workbook so the command is always available.

  10. Thank a lot very very helpful advised in this page

  11. The last cell in my bulleted series has a good deal more text than the others and is formatted to wrap. Rather than getting a bullet point in the last cell, all I see is ############################. No text or anything. Any ideas? Yes, I have deselected 'wrap text'.

    • Hello!
      Unfortunately I was unable to replicate your problem. Describe your actions in more detail. What is written in your cell?

      • Kathryn's problem is not specific to wrapped text, but occurs with other long text. To reproduce: In A1, put the number 250. In A2, put =REPT("i",A1). In A3, put =A2. To A3, assign a custom format with a text component that starts with a bullet. Increase the value in A1 incrementally. When the number in A1 plus the length of the literals in the text component (aside from the @) of the custom format exceeds 255, A3 fills with # (pound signs). (Excel 365)
        Undocumented limitation on custom formats? Or a bug?

  12. Very Simple Right Click to make Bulletized List in Text Box, Never come across for so many years. Thanks a lot for this tip.

  13. Very much helpful and details and more understandable, thank you so much for such wonderful solution relating to insert the bullet in excel.

  14. finally found my answer... Thx

  15. thanks

  16. Super helpful! I've needed the ability to insert a new line for ages and didn't know of this short cut!

    Thanks tons!

  17. Thanku

  18. great work

  19. Very helpful! Thank you as you have saved me a lot of time from researching.

  20. how to put bullets in a cell only not in different cell

  21. Thank you!

  22. Dear Sir,
    I want to write 004.569 or 005.5689 4 in excel, how can i write it in excel?

    • '004.569 you can

  23. thank you

  24. SUPER helpful - this goes into the top of my toolbox. Thank you!!

  25. Incredibly helpful! Thanks.

  26. You are awesome!!!!!!!!!!! Thank you for posting the options.

  27. Awesome. Thank you so much.

  28. Great Help. Thanks!

  29. Amazing how little things can make on so happy. Me too, have been in need of bullets in Excel for ages, and when I read this advice and tried it out, was very very happy! Thanks so much!

  30. I've been having trouble with this process for ages. I don't have a number pad on my laptop, and even using short keys to enable number lock etc. didn't work. Your blog is the best. I read the first instruction, tried it and it worked like a charm. Excellent. Thank you.

  31. Truck of thanks

Post a comment



Thank you for your comment!
When posting a question, please be very clear and concise. This will help us provide a quick and relevant solution to
your query. We cannot guarantee that we will answer every question, but we'll do our best :)