Insert bullets in a worksheet

Unlike Microsoft Word, Excel does not provide a button to create a bulleted list in text. However, there are several ways that you can add bullets to a worksheet in Excel.

Bulleted list in a cell

What do you want to do?


Insert a bullet symbol into a cell

To quickly add a bullet symbol to a cell, double click in the cell where you want to add your bullet symbol, and then press ALT+7 or ALT+9 using the numeric keypad on your keyboard.

 Note    If you do not have a numeric keypad on your keyboard or are using a laptop computer, you can enable Num Lock so that you’ll have a numeric keypad to use. On most laptops, to enable Num Lock, you press SHIFT+Num Lock or Fn+Num Lock. If your laptop (typically a smaller model, such as a netbook) doesn’t have a Num Lock key, see its documentation to learn how to enable it.

 Tip    To quickly add additional bullet symbols within the same cell, press ALT+ENTER to add a line break within the cell, and then repeat the ALT+7 or ALT+9 key combination.

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

       Tip   Do this when you want to insert bullets in a separate column from the one that contains the list items.

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

 Tip   Do this when you want the bullet and list items to appear in the same cell. To break existing text to a new line or to insert a new line in a cell so that you can create a list, press ALT+ENTER.

  1. On the Insert tab, in the Text group (Excel 2007) or Symbols group (Excel 2010), click Symbol.

Excel Ribbon Image

  1. In the Symbol dialog box, on the Symbols tab, in the Font box, click the font that you want to use.
  2. In the Symbol box, use the scroll bar to locate the bullet 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 selecting a font, such as Wingdings.

  1. Click the bullet symbol that you want, click Insert, and then click Close.
  2. To add more bullets, do one of the following:

 Note   The fill handle is displayed by default, but if it is not available, you must display it first. For information about how to display the fill handle, see Display or hide the fill handle.

Copy a bulleted list from Word

If you have already created a bulleted list in Word, and want to copy that bulleted list into Excel, do the following:

Copy the bulleted list in Word, and then in Excel, do one of the following:

  • To add the entire bulleted list to a single cell, double click in the cell where you want to paste the bulleted list, and then press CRTL+V.
  • To add the bulleted list to the worksheet so that each bulleted item appears in its own row, click in the cell where you want the first bulleted list item to appear (do not double click the cell), and then press CRTL+V.
 
 
Applies to:
Excel 2010, Excel 2007