How to Insert Bullet Points in Excel

Capturing data in the right way is important.

In Excel, most of the time we use serial numbers but when you are working on lists the best way is to use bullet point. I mostly use bullet-point lists to capture my day-to-day work (To-do lists, Important points).

Now the bad news is. In Excel, there is no default way to insert a bullet point as we have in Microsoft Word.

But here is the good news. A few days back I have realized that actually, we can use 8 different ways to insert bullet points in Excel.

And, all these methods can be useful in different situations. So, today in this post, I’d like to share with you all those methods.

Add a Bullet Point from Symbol Dialog Box

I am sure you have used this method before.

  1. Select the cell in which you want to add a bullet point
  2. Go to Insert Tab ➜ Click on Symbol.
    click-on-symbol-to-insert-bullet-point-in-excel
  3. Once you click on the symbol button, you’ll get a symbol dialog box.
  4. In symbol dialog box, you have a lot of smart symbols to use as a bullet point or you can simply use a black dot.
  5. Once you choose your bullet point, just click on the insert to add in the cell.
    open-symbol-dialog-box-to-insert-bullet-point-in-excel-1

Here are some symbols which you can use for a list in Excel as a bullet point.

Use Different Symbol From Dialog Box To Insert Bullet Point In Excel

Insert Bullet Points with a Shortcut Key

Shortcut keys are the best way to insert a bullet point if you don’t have the time to play with a symbol dialog box. We have two different shortcut keys and you can use any of these.

Use Shortcuts Keys To Insert Bullet Point In Excel
  1. Select the cell in which you want to add a bullet point.
  2. Press F2 to edit the cell.
  3. Hold the alt key and press 7 or 9 to insert a bullet.

Both shortcut keys will give you different types of bullets. If you want to add a dark dot for bullet points you can use Alt + 7 or if you want to add a circle, you can use alt + 9.

Use CHAR Function for Bullet Points

You can also use CHAR(149) to add a bullet in a cell. This method is helpful if you want to insert a bullet in all the cells using a formula in the formula bar in the cell where you need to insert it.

  1. Select the cell in which you want to add a bullet point.
  2. Enter =CHAR(149)&” “&A1
    use-char-to-insert-bullet-point-in-excel-1
  3. Now, drag the formula up to the cell in which you want to add the bullet.
    use-char-function-to-insert-bullet-point-in-excel.gif

Custom Formatting for Bullet Points

It’s a one-time setup. All you have to do is to create a custom format to insert bullet points. Just follow these simple steps.

  • Press Ctrl + 1 and you will get a format dialog box.
  • Under the number tab, select custom.
  • In the type input bar, enter the following formatting.

● General;● General;● General;● General

  • In the type input bar, enter the following formatting.
Use Custom Formatting To Insert Bullet Point In Excel

How it Works

Let me give you a short note to use custom formatting for bullet points. In custom formatting, you have to mention 4 different formats from positive, negative, zero, and text. I have used a black dot for all these four types. And now, when you insert a text or any number whether positive or negative, it will add a bullet in front of it.

Add Bullet Points in a Text Box

To insert bullet points in the text box is the quickest way. You don’t have to run here and there from bullets. Follow these simple steps.

  1. First of all, insert a text box.
  2. Edit the text box and right click
  3. Click on the bullet option and select the bullet style to apply.
    use-text-box-to-insert-bullet-point-in-excel
  4. Once you select your bullet style it will automatically insert a bullet at the start of each line.
    text-box-list-to-insert-bullet-point-in-excel

You can also use the numbers in a text box by using the same method.

Use Wingdings & Webdings Fonts for Bullet Points

Both of the font styles will show an icon instead of an alphabet or number. If you enter any number or alphabet you will get a cool icon instead.

You’ll even get a different symbol for a capital letter and a lower letter. To insert a simple black dot use small “l” & small “n” in Webdings & Wingdings respectively.

Use Wingdings & Webdings Font Style To Insert Bullet point In Excel

Bullet Points in a Cell Comment

You can also use bullet points in cell comments using symbols.

  1. First of all, insert a comment in a cell.
  2. Edit that cell comment.
  3. Go to Insert Tab ► Click on Symbol.
  4. Add any symbol which you want to add.
  5. Copy that symbol before the start of each line.
Use Cell Comment To Insert Bullet point In Excel

Use Smart Art to Create a Bulleted List

Smart art is also an effective way to create an organized list of bullet points.

  • Go to Insert Tab ► Smart Art Graphics.
  • From categories select list.
  • Select the type of smart art you want and click OK.
how to insert bullet points in excel using smart art

Conclusion

Bulleted lists are handy when you want to create lists and you know eight different ways to insert bullet points in Excel. If you ask me custom formatting is my favorite way for this as it’s a one-time set-up.

Which one is your favorite?

Please share your views with me in the comment section. I’d love to hear from you, and please, don’t forget to share this post with your friends, I am sure they will appreciate it.

 This tutorial is a part of our Basic Excel Skills, and if you want to sharpen your existing Excel Skills, checkout these Excel Tips and Tricks. But if you are just getting started with Excel, check out this tutorial on Excel Basics.

Related Tutorials

  1. How to Insert Delta Symbol Δ in Excel in a Cell
  2. How to Insert/Type DEGREE Symbol in Excel
  3. How to Quickly Insert a Check Mark Symbol in Excel
  4. How to Insert a Timestamp in Excel

15 thoughts

Leave a Comment

Your email address will not be published.

  1. Re: Bullet symbol in Excel comment
    Is there a way to real bulleted lists with indent for multi-line entries, or just a symbol?

    Reply
  2. On my keyboard, Alt + 7 and Alt + 9 only work if you use the number keypad for the 7 and 9, not the regular numbers across the top (under the function keys).

    Reply
  3. Hi..

    Good info..

    In some laptop in place of Alt+9 / Alt+7 for bullets, we need to use Alt+Function Key+9 / Alt+Function Key +7.. Just sharing for the benefit of others for whom it is not working like mine.

    Also for me, in webding font, need to put “=” in place of “l” for bullet. Correct me if I am wrong.

    FYI – Even “r”, “t”, “u” etc. in winding font gives good bullets.

    Reply
  4. nice information,
    i like excel because mostly all and any work can be done in excel easily.
    we can use quick access toolbar to add symbol option.

    Reply
  5. I do like the custom formatting but you can still only place one bullet per cell. It would be nice if you could have a bulleted list of multiple bullets per cell. Does anyone know how this can be done. Using Excel on Mac

    Reply
  6. Is there a way to do custom formatting for one cell? So that the list of items is bulleted on each item (via ALT+ENT)? Thank you!

    Reply
  7. Good information. You can also create a custom format using the @ symbol, which is a kind of wild card that represents all of the text that follows. Type Alt+0149 (or Alt+7, Alt+9 as noted above), press the space bar, type @, and then Enter to create the custom format.

    Reply