Show All

Hide All

Unlike Microsoft Word, Microsoft Excel does not provide a button to create a bulleted list in text. To add bullets to worksheet text, you need to insert a symbol.

1. Do one of the following:
   • To add a bullet to an empty cell on the worksheet, click the cell.

     You may want to do this if your bullets will be in a separate column from the list items.

   • To add a bullet to a cell that contains text, double-click the cell, and then place the insertion point where you want the bullet to appear.

     Do this when you want the bullet and list item to appear in the same cell.

2. On the Insert menu, click Symbol.
3. On the Symbols tab, in the Font box, click the font that you want to use.
4. Use the scroll bar on the right side to find the symbol that you want to insert.

   Tip   Different fonts provide different symbols. If your font does not provide the bullet or other symbol that you want, try a selecting a font like Wingdings.

5. Click the bullet or symbol that you want, click Insert, and then click Close.
6. To add more bullets, you can copy and paste the first one that you inserted.

   Or, if the bullet is in its own cell, you can drag the fill handle (fill handle: The small black square in the lower-right corner of the selection. When you point to the fill handle, the pointer changes to a black cross.) to repeat the symbol in adjacent cells.