This article is a tutorial on how to add bullet points to entries in Microsoft Excel.
You may also like: How to Indent Text in Excel
Steps to add bullets to a cell in Excel
Let’s get started with this step-by-step guide to adding bullets in cells. First, we take an example of a list of items to be bulleted.
We are looking forward to applying bullet points to this list of items; here is how.
- Select the cells to which you want to apply bulleting.
- Go to the Home tab.
- Under the Number group, click the Number Format button.
- A new window opens named Format Cells.
- Under the Number tab, select the Custom category.
- Scroll to the lowest part and select • @ and press OK.
You can see that all selected entries have been bulleted as shown in the image above.
Custom bullet points in Excel
To add custom bullet styles in Excel, do as follows next. First, we take an example of a list of items to be bulleted.
- Select all the items or cells you want to add custom bulleting to.
- Press CTRL+1 to open formatting options.
- Click Custom at the bottom on the left.
- In the text box, type ALT+7 and @ after a space for • filled style.
- ALT+8 and @ after a space for ◘ highlighted bullet style
- ALT+9 and @ after a space for ○ unfilled style.
- ALT+4 and @ after a space for ♦ diamond shape style.
- Click OK once you’re done.
You can now see that a custom bullet style has been added to this list of fish.
Add bullet points in a text box in Excel
You can easily add symbols and numbered bulleting in a text box in Excel.
Here is an example of a text box containing a list of stationery tools.
- Select the text in the text box or press CTRL+A.
- Right-click on it and click Bullets to add bulleting to all texts inside.
- If you want to add custom bulleting styles, then pull right on Bullets and select a symbolic bullet style.
- To insert a numeric bullet style, click on Bullets and Numbering below and go to the Numbered tab.
- To create a custom bullet style of your own, go to the Bulleted tab in Bullets and Numbering and click Customize below.
- Select the style you like and click OK in the Symbol window.
You can see that bulleting has been added to this textbox.
Keyboard shortcut to add multiple bullet points within a cell
We have a cell with a list of different fish types below. You can add text in a new line within the same cell by pressing ALT+ENTER. Let’s add bullet points to each line in the cell.
To add bullet points to each line in the cell, do as follows.
- Double-click on the cell to enable editing it.
- Click where you want to add a bullet.
- Press ALT+7 on the right side of your keyboard in the numeric keypad to add a bullet.
You can now see that a bullet point has been added to each line.
Inserting bullets with the Symbol option
There are multiple ways you can add bullets to texts in Excel. You can even add bullet symbols from the Symbol option in Excel. Let’s learn how.
- Select a blank cell or click behind the text you want to add bullets to.
- Go to the Insert tab.
- Under Symbols group, select Symbol.
- A dialogue box named Symbol opens through which you can add bullets.
- Scroll until you find the bullet symbol and click Insert.
- You can add bullets in a new line within the same cell by pressing ALT+ENTER and repeating the aforementioned procedure.
Inserting bullets using SmartArt Graphics in Excel
To add bullet points to the texts in a shape.
- Select the textbox to which you want to add bullets.
- If you want to add bullets to all textboxes, then press and hold CTRL and click the other boxes one by one after clicking the first box normally.
- Go to the Design tab.
- Click Add Bullet.
- Or press ALT+7 before a text to add a bullet.
You can see that a bullet point has been added to the SmartArt in Microsoft Excel.
Conclusion
This was a complete tutorial on adding bullet points to entries in Microsoft Excel. Follow these steps carefully to add bullets to your data properly. Don’t forget to comment your thoughts below!