Insert bullets in a worksheet

Important notice for users of Office 2003    To continue receiving security updates for Office, make sure you're running Office 2003 Service Pack 3 (SP3). The support for Office 2003 ends April 8, 2014. If you’re running Office 2003 after support ends, to receive all important security updates for Office, you need to upgrade to a later version such as Office 365 or Office 2013. For more information, see Support is ending for Office 2003.

Unlike Microsoft Word, Microsoft 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 menu, click Symbol.
  2. On the Symbols tab, in the Font box, click the font that you want to use.
  3. 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.

  1. Click the bullet or 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 Microsoft Office 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 2003