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.
How to Make a Bulleted List in Excel: 9 Methods
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.
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.
- In cell (B5) you will find a bullet point.
- Now drag down the Fill handle to get the bullet point with all names.
- Thus we will get a bulleted list.
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.
- The bullet symbol will appear in the cell.
- Drag down the Fill handle.
- This way we can easily get our bulleted list.
Read More: How to Generate List Based on Criteria in Excel
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.
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.
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.
- After that, we will get our desired bulleted list.
Read More: How to Make a Numbered List in Excel
4. Make a Bulleted List in a Single Cell in Excel
To make a bulleted list within a single cell we will apply some keyboard shortcuts.
Step 1:
- Select a cell (B5).
- Press ALT+7. A bullet point is inserted.
Step 2:
- Now type your
- To get to the next line, press ALT+Enter.
- The cursor will move to the next line.
- Now again press ALT+7 to get the bullet point and type data.
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
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.
- Now open your Excel workbook.
- Select the desired cell and press CTRL+V to paste.
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.
- Press CTRL+Enter.
- A bullet point is inserted in the cell.
- Drag down the Fill handle to get bullet points in every cell.
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.
Step 2:
- Select a cell (C5) to show output.
- Apply the formula-
=CHAR(149)&" "&B5Where,
- The CHAR function returns the character with a specific code.
- B5 is the reference data.
- 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.
Here we got our bulleted list with the help of a function.
Read More: How to Create List from Range in Excel
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”.
Step 2:
- Now press “L”.
- A bullet point is inserted.
- Drag down to fill all the cells.
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”.
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.
- Click on the Arrow mark to type.
- Now type your list names in the desired sections.
- Click on SmartArt to view your desired bulleted list.
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.
- 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 and 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.
Download Practice Workbook
Download this practice workbook to exercise while you are reading this article.
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!
