In this article, you will learn how to add Auto Bullet Points in Excel using Custom formatting.
To add the auto bullet point in excel range below are the steps-
- Select the excel range.
- Press Alt+O+E to open the Format Cells window.
- Go to Number tab.
- Got to Custom.
- Put the below code in Type box-
“ ■ General; ■ General; ■ General; ■ General”
You can take any other symbol in place of square (■) .
![Format Cells window](https://www.pk-anexcelexpert.com/wp-content/uploads/2019/08/Auto-Bullet-Points-in-Excel-1.jpg)
Now if you will type anything in selected range that will be converted into bullet point
![Auto Bullet Points in Excel](https://www.pk-anexcelexpert.com/wp-content/uploads/2019/08/Auto-Bullet-Points-in-Excel.jpg)