Friday, 29 May 2015

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.

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.

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.