Adding Bullets in Excel – Knowligent
Adding Bullets in Excel

Adding Bullets in Excel

HomeHow to, TechAdding Bullets in Excel

Adding bullets in Excel can be tricky: Excel doesn't offer a font-formatting tool for bullets. However, there are many times when you need to add a bullet for every cell, or multiple bullets in each cell. This article looks at the different ways you can add bullets in Excel.

Add Bullets to an Excel Cell | Create a Bullet List in Excel

One of the easiest ways to add bullets in Excel is by using keyboard shortcuts.

To add one bullet per cell, double-click the first cell where you want a bullet and press Alt+7 to insert the bullet. Then type the item you want to appear after the bullet.

To quickly add bullets before opening a list, select the bottom-right corner of the cell and drag it down the number of cells you want to fill with bullets. Do this before typing any text after the bullet.