How to create a bulleted or numbered list in Microsoft Excel

Updated: 03/07/2020 by Computer Hope
Microsoft Excel

A bulleted and numbered list is an available feature in Microsoft Excel, but not as commonly used as in word processing documents or presentation slides. By default, the bulleted and numbered lists option is hidden in Excel and must be added to the Ribbon. Additionally, a bulleted and numbered list cannot be added to a cell in Excel. A text box must be created, and then a bulleted or numbered list is added to that text box.

Create a bulleted or numbered list in Excel

Add bulleted and numbered list option to the Ribbon

  1. Open Microsoft Excel.
  2. Click the File tab in the Ribbon.
  3. Click Options in the left navigation menu.
  4. In the Excel Options window, click Customize Ribbon in the left navigation menu.
  5. On the right side of the Excel Options window, click the Home entry in the Main Tabs box.
  6. Click the New Group button below the Main Tabs box.

Add new group to Excel Ribbon

  1. A new group is added to the Home group. Click the New Group (Custom) entry, and click the Rename button.

Rename new group in Excel Ribbon

  1. Enter a new name, like Bullets or Bullet Lists, for the group.
  2. On the left side of the Excel Options window, click on the Choose commands from drop-down list and select All Commands.
  3. In the list below, scroll down and find the Bullets and Numbering option. Click on that entry and drag it to the new group you created on the right.

Add option to new group in Excel Ribbon

  1. Click the OK button to create the new group on the Home tab in the Ribbon, with the Bullets and Numbering option in it. The new group and option is found on the Home tab, on the far right side.

Add a text box to a worksheet

  1. Click the Insert tab in the Ribbon.
  2. On the Insert tab, click the Text option on the far right side, and select the Text Box option.

Add text box in Excel

  1. In the worksheet, press and hold the left mouse button where you want to create the text box. Drag the mouse down and to the right, creating the text box with the desired size.

Add bulleted or numbered list to the text box

  1. Click in the text box you added to the worksheet.
  2. Click the Home tab in the Ribbon.
  3. Click the Bullets and Numbering option in the new group you created. The new group is located on the far right side of the Home tab.
  4. In the Bullets and Numbering window, select the type of bulleted or numbered list you want to add to the text box and click OK.

Add bullet list in Excel

  1. Type the text for each bullet point in the text box, pressing Enter to create the next bullet point.
  2. After entering the text for all desired bullet points, you can move the text box to any location in the worksheet. You can also resize the text box to better fit the bulleted or numbered list, if necessary.