How to Add Bullet Points Using Symbols in Excel
You can also use the Symbols option in the Insert tab to add bullet points to your worksheet. It is very difficult to find the bullet symbol in such a huge list of symbols. So, you can also type the unique code provided for each symbol. We have compiled, the codes of the most commonly used bullet symbols.
Symbol |
Character code |
---|---|
• |
2022 |
◦ |
25E6 |
● |
25CF |
◌ |
25CC |
○ |
25CB |
◊ |
25CA |
▫ |
25AB |
▪ |
25AA |
□ |
25A1 |
The following are the steps:
Step 1: Go to the Insert Tab
Step 2: Under Symbols group. Click on the Symbols option
Step 3: Symbols dialogue box appears. In the lower right corner, there is an option name Character code. You can add code according to your wish. For example, type 2022 in the character code. Now, click on Insert
Step 4: A black bullet point is inserted
How to Insert Bullet Points in Excel: Quick and Top Ways
Bullet points can be used very frequently in Excel. MS Excel is all about numbers and to make our data more representable and user-friendly we can use bullet points. Unlike in PowerPoint and Word, there is no direct way to add bullet points in Excel.
In this article, we will discuss different methods to add a bullet point in Excel.