How to Add Bullet Points in Excel

You can easily type in bullet point with your keyboard by clicking on the beginning of each text or value, and use Keyboard shortcuts to press ALT+0149. We are going to do it in a more elaborated manner.

Data layout

First have a look at this layout data:

bullet list data

Adding bullet points

Click on the beginning of each cell and type in ALT+0149 to make the bullet list.

bullet list

Note: We expanded column A. It is not necessary, but you could do it. You can use CTRL+V to put the bullet point on all the text and numbers, after copying it with CTRL+C.

Using the Symbol Dialog Box

  • Click on the cell where you want to insert the bullet point.
  • Go to the "Insert" tab in the ribbon.
  • Click on the "Symbol" button in the "Text" group.
  • In the "Symbol" dialog box, select "Wingdings" in the font drop-down list.
  • Scroll down to find the bullet point symbol.
  • Select the bullet point symbol and click "Insert".
  • The bullet point symbol will be inserted into the cell.

Using Keyboard Shortcuts

  • Click on the cell where you want to insert the bullet point.
  • Press "Alt" + "7".
  • The bullet point symbol will be inserted into the cell.

Using a Custom Number Format

  • Select the cells where you want to insert the bullet points.
  • Right-click the selected cells and choose "Format Cells".
  • Go to the "Number" tab in the "Format Cells" dialog box.
  • Select "Custom" from the Category list.
  • Type "•" in the "Type" field.
  • Click "OK".
  • The bullet point symbol will be inserted into the cells and any text entered in these cells will be formatted with the bullet point symbol.

Using a Formula

  • In a cell, enter the formula =CHAR(149).
  • Press "Enter".
  • The bullet point symbol will be displayed in the cell.
  • Copy the cell that contains the bullet point symbol.
  • Select the cells where you want to insert the bullet points.
  • Right-click the selected cells and choose "Paste".
  • The bullet points will be inserted into the cells.

In conclusion, there are several ways to add bullet points in Excel. You can use the Symbol Dialog Box, Keyboard Shortcuts, Custom Number Format, or a Formula. Whichever method you choose, you can easily add bullet points in Excel to organize and present information in a clear and concise manner.