How to Make a Bulleted List in Excel (9 Methods)

In Microsoft Word, it is easy to make a bulleted list with just a single click. But in Excel is it possible? Yes, it is. Today in this article, I am going to show you how to make a bulleted list in excel. You can visit this link too.


Download Practice Workbook

Download this practice workbook to exercise while you are reading this article.


9 Methods to Make a Bulleted List in Excel

The following article contains 9 methods to make a bulleted list in excel. Suppose we have a dataset of some employee names. Now we need to make a bulleted list out of those names.

Make a Bulleted List in Excel

1. Make a Bulleted List Using the Symbol Dialog Box in Excel

With the help of the Symbol Dialog Box, you can choose any symbol in a dataset. Today I am going to show you how to make a bulleted list using the symbol dialog box.

Step 1:

  • Select a cell (B5) to put a symbol.
  • Go to Insert > Symbols > Symbol.

Step 2:

  • A new window “Symbol” will appear.
  • Choose a bullet point symbol from the list.
  • Press Insert.

Make a Bulleted List Using the Symbol Dialog Box in Excel

  • In cell (B5) you will find a bullet point.
  • Now drag down the Fill handle to get the bullet point with all names.

Make a Bulleted List Using the Symbol Dialog Box in Excel

  • Thus we will get a bulleted list.

Make a Bulleted List Using the Symbol Dialog Box in Excel

Sometimes it becomes difficult to find the bullet point symbol from the list. At that time, we have to use proper codes to find the right symbol. Here, we will use the proper code to find the bullet symbol.

Step 3:

  • Go to the “Symbol” dialog box.
  • From the drop-down list choose “Unicode(hex)”.
  • In the character code put”2022”.
  • Click Insert.

Make a Bulleted List Using the Symbol Dialog Box in Excel

  • The bullet symbol will appear in the cell.
  • Drag down the Fill handle.

Make a Bulleted List Using the Symbol Dialog Box in Excel

  • This way we can easily get our bulleted list.

Make a Bulleted List Using the Symbol Dialog Box in Excel

Read More: How to Generate List Based on Criteria in Excel (4 Methods)


2. Use Keyboard Shortcuts to Make a Bulleted List

In the following, I am going to explain some keyboard shortcuts to make a bulleted list quickly.

Steps:

  • Select a cell (B5).
  • Press ALT+7 or ALT+0149.
  • A bullet point will appear in the cell.
  • Drag down the Fill handle.

Thus we will get our all cells with a bullet point.

Use Keyboard Shortcuts to Make a Bulleted List


3. Apply Custom Format to Make a Bulleted List

At some point, we may need the bullet point with the dataset in the same cell. Custom format is the solution for this.

Step 1:

  • Select all the cells with names.
  • Enter CTRL+1 to bring up the Format Cells.

Apply Custom Format to Make a Bulleted List

Step 2:

  • Choose the “Number” Tab. Go to “Custom”.
  • In the type section, type a bullet symbol with shortcut ALT+7.
  • Add space and type “@”.
  • Press OK.

Apply Custom Format to Make a Bulleted List

  • After that, we will get our desired bulleted list.

Apply Custom Format to Make a Bulleted List

Read More: How to Make a Numbered List in Excel (8 Methods)


4. Make a Bulleted List in a Single Cell in Excel

To make a bulleted list in a single cell we will apply some keyboard shortcuts.

Step 1:

  • Select a cell (B5).

  • Press ALT+7. A bullet point is inserted.

Make a Bulleted List in a Single Cell in Excel

Step 2:

  • Now type your
  • To get to the next line, press ALT+Enter.

Make a Bulleted List in a Single Cell in Excel

  • The cursor will move to the next line.
  • Now again press ALT+7 to get the bullet point and type data.

Make a Bulleted List in a Single Cell in Excel

This way you can make your dataset with a bulleted list in a single cell.

Read More: How to Make a To Do List in Excel (3 Easy Methods)


5. Create a Bulleted List by Pasting It from Microsoft Word

Imagine we have our bulleted list with data in Microsoft Word. But we need the dataset in our Excel workbook. We can easily Paste it into our excel workbook. Following the method, we will describe it.

Steps:

  • Select the dataset with bullet points from the word file.
  • Press CTRL+C to copy.

Create a Bulleted List by Pasting It from Microsoft Word

  • Now open your excel workbook.
  • Select the desired cell and press CTRL+V to paste.

Create a Bulleted List by Pasting It from Microsoft Word

Here we got our dataset with a bulleted list in a single cell.


6. Apply CHAR Function to Make a Bulleted List

We can create a bulleted list with help of the CHAR function too.

Step 1:

  • Choose a cell. Here, we have chosen cell (B5).
  • Enter the formula-
=CHAR(149)

Where,

  • The CHAR function returns the character specified by a number.

Apply CHAR Function to Make a Bulleted List

  • Press CTRL+Enter.
  • A bullet point is inserted in the cell.
  • Drag down the Fill handle to get bullet points in every cell.

Apply CHAR Function to Make a Bulleted List

This way we can make our bulleted list.

But sometimes, we might need to make the bulleted list in the same cell. In the following with the help of the CHAR function, we can do it too.

Apply CHAR Function to Make a Bulleted List

Step 2:

  • Select a cell (C5) to show output.
  • Apply the formula-
=CHAR(149)&" "&B5

Where,

  • The CHAR function returns the character with a specific code.
  • B5 is the reference data.

Apply CHAR Function to Make a Bulleted List

  • Click CTRL+Enter.
  • We will get our desired name with a bullet point.
  • Drag down the Fill handle to get all the names with a bullet point.

Apply CHAR Function to Make a Bulleted List

Here we got our bulleted list with the help of a function.

Apply CHAR Function to Make a Bulleted List


7. Use Special Fonts to Make a Bulleted List

You can make a bulleted list with special fonts too.

Step 1:

  • Select a cell (B5).
  • From the Font option select “Wingdings”.

Use Special Fonts to Make a Bulleted List

Step 2:

  • Now press “L”.
  • A bullet point is inserted.

Use Special Fonts to Make a Bulleted List

  • Drag down to fill all the cells.

Use Special Fonts to Make a Bulleted List

Thus you will get your bulleted list. In the following, I have put some keys with different bullet points. You can use them after changing the font to “Wingdings”.

Use Special Fonts to Make a Bulleted List


8. Make a Bulleted List Using SmartArt in Excel

If you are looking for a creative way of making a bulleted list then you are in the perfect place. In this method, we will use SmartArt to make a bulleted list.

Step 1:

  • In your workbook, select “SmartArt” from the “Insert”

Step 2:

  • A new window will appear “Choose a SmartArt Graphic”.
  • From the list choose “Vertical Bullet List”.
  • Click OK.

  • A SmartArt graphic is selected.

Make a Bulleted List Using SmartArt in Excel

  • Click on the Arrow mark to type.

Make a Bulleted List Using SmartArt in Excel

  • Now type your list names in the desired sections.

  • Click on SmartArt to view your desired bulleted list.

Make a Bulleted List Using SmartArt in Excel


9. Insert Bullet Point in a Text Box in Excel

In the following, I am going to describe how we can insert bullet points in a text box.

Step 1:

  • Select a cell (B4).
  • Go to Insert > Text > Text Box.

Step 2:

  • A text box will appear.

Insert Bullet Point in a Text Box in Excel

  • Adjust the text box by dragging.
  • Click the right button on the mouse.
  • From the options, select “Bullets” and choose desired bullet point list.

  • Thus you can add bullet points in a text box.
  • Now, type your list names to make a bulleted list.


Things to Remember

  • When typing numbers applying these shortcuts, use the number pad on your keyboard. Otherwise, it won’t work.
  • When typing shortcuts on your laptop’s keyboard, you can press SHIFT + Num Lock or Fn+ Num Lock to activate the number pad.

Conclusion

In this article, I have covered all the methods to make a bulleted list in excel. Hope you find it useful. If you find any problems regarding this don’t forget to share in the comment section below. Thanks!


Related Articles

Wasim Akram

Wasim Akram

Hi! my name is Wasim Akram. I am a graduate in mechanical engineering from Ahsanullah University of Science & Technology. I am passionate about learning new things and writing articles. I write article about Microsoft Excel and it's my favourite thing to do.

We will be happy to hear your thoughts

Leave a reply

ExcelDemy
Logo