how to insert bullet points in excelBullet point list is a useful method to stay organized, but unfortunately there is no formal method to insert bullet points in excel.

We don’t have any option in excel ribbon as we have in Microsoft Word.

But that doesn’t mean we can’t insert bullet points in excel.

In fact, we have more than one way and you can pick any one which you think is perfect for you.

Here I have listed 6 different ways to insert bullet points in excel.

Use Symbols To Insert Bullet Points In Excel

I bet you have used this method before.

  • Select the cell in which you want to add a bullet point.
  • Go to Insert Tab ► Click on Symbol.

Click On Symbol To Insert Bullet Point In Excel

  • Once you click on the symbol button, you’ll get a symbol dialog box.
  • 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.
  • 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

Here are some symbols which you can use as a bullet point.

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

Use Shortcut Keys

Shortcut keys are the best way to insert a bullet point if you don’t have the time to play with 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

  • Select the cell in which you want to add a bullet point.
  • Press F2 to edit cell.
  • Hold alt key and press 7 or 9 to insert a bullet.

Both shortcuts keys will give you different type of bullets.

If you want to add a dark dot for bullet point you can use Alt + 7 or if you want to add a circle, you can use alt + 9.

Use CHAR Function

You can also use CHAR(149) to add a bullet in your cell.

This is a helpful method if you want to insert a bullet in all the cells using a formula.

  • Select the cell in which you want to create a bullet point.
  • Enter =CHAR(149)&” “&A1 (here I have my list point in cell A1).

Use CHAR To Insert Bullet Point In Excel

  • Now, drag the formula up to the cell in which you want to add the bullet point.

Use CHAR Function To Insert Bullet Point In Excel

Use Custom Formatting

This method is the best.

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 & you’ll get a format dialog box.
  • Under Number Tab, select Custom.
  • In Type input bar enter following formatting.
  • Click Ok.

Use Custom Formatting To Insert Bullet Point In Excel

How Does It Work?

Let me give you a short note to use custom formatting for bullet points.

How Custom Format Works To Insert Bullet Point In Excel

In custom formatting, you have to mention 4 different formats from positive, negative, zero & 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.

Insert Bullet Points In Excel Using 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.

Just follow these simple steps.

  • First of all, insert a text box.
  • Edit the text box & right click.
  • Click on the bullet option & Select the bullet style to apply.

How-Custom-Format-Works-To-Insert-Bullet-Point-In-Excel

  • 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 Font Style

This is another awesome way.

Both of the font styles will show an icon instead of 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 capital letter & lower letter.

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

To insert a simple black dot use small “l” & small “n” in Webdings & Wingdings respectively.

[Bonus Tip]

Insert Bullet Points In Cell Comment

You can also use bullet point in cell comment using symbols.

Steps:

  • First of all, insert a comment in a cell.
  • Edit that cell comment.
  • Go to Insert Tab ► Click on Symbol
  • Add any symbol which you want to add.
  • Copy that symbol before the start of each line.

use cell comment to insert bullet point in excel

Insert Bullet Points With Smart Art

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

Here are the steps.

  • 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

Sample File

download sample file to learn how to insert bullet point in excel

Last Words

Bullet points are handy when you want to create a list.

Now you have six different ways to insert bullet points in excel and you can use any method which you like.

Over To You

Do you ever use bullet points in excel before?

Do you know any other way?

Using Custom Formatting is my favorite way to insert bullet points.

Which one is your favorite?

More Excel Hacks