How to Add a Bullet in Excel

As of Excel 2013, no current or past version of Excel has an automated bulleted list feature akin to the feature in Microsoft Word. Usually, lists in Excel use each cell as an entry, rather than relying on bullets. Even so, you can manually insert bullet points as symbols into cells or cell formatting, if you prefer.

...
Cell formatting changes how cells look without affecting function.
credit: Image courtesy of Microsoft

Step

Type Alt-7, Alt-8 or Alt-9, using the numbers on the numeric keypad, to insert a solid bullet, a bullet outline or a hollow bullet, respectively, in Excel.

...
Add bullets to text.
credit: Image courtesy of Microsoft

Step

This one-step solution works for text lists, but when performing calculations, bullets prevent formulas from working. Instead, use the following method to add bullets that won't interfere.

...
Choose Format Cells.
credit: Image courtesy of Microsoft

Step

Select all cells where you want to add bullets to numbers. Right-click any cell in the selection and choose Format Cells from the drop-down menu. It's okay to use either blank cells or cells that already contain data.

...
Enter a custom formatting style.
credit: Image courtesy of Microsoft

Step

Select Custom on the Number tab. In the Type box, use the Alt combinations of Alt-7, Alt-8 or Alt-9 to create the type of bullet you want. Immediately after the bullet, type " "0. The single space within quotation marks adds a space after the bullet for a cleaner style, which you can optionally omit. The 0 represents the number in each cell. In total, this code adds a bullet and a space prior to each cell's numeric value.

Step

Click OK to apply the formatting.

...
Use the formatted cells.
credit: Image courtesy of Microsoft

Step

Enter a number in a formatted cell. After you press "Enter" or click out of the cell, your bullet will appear automatically. Formulas that reference these cells work as expected and also adopt the bullet point.