Table of Contents

Bullet Points

This page illustrates 4 ways to insert bullet points in Excel. You can use a keyboard shortcut insert a symbol create a custom number format (our favorite) or use the CHAR function.

Keyboard Shortcut

If you have a number pad on the right side of your keyboard use these keyboard shortcuts to add bullet points.

1. To insert a filled round bullet point press Alt + Numpad 7.

Filled Round Bullet Point

2. To insert a hollow round bullet point press Alt + Numpad 9.

Hollow Round Bullet Point

Symbol

If you don’t have a number pad on the right side of your keyboard execute these steps to add bullet points.

1. On the Insert tab in the Symbols group click Symbol.

Click Symbol

2. Select a font from the drop-down list type 2022 in the Character code box and click Insert.

Insert Bullet Point

Result:

Filled Round Bullet Point

3. To insert multiple bullet points in a single cell press Alt + Enter to start a new line in an Excel cell.

Multiple Bullet Points

Custom Number Format

Create a custom number format and inserting a bulleted list in Excel will be a piece of cake!

1. Select the range A1:A3.

Select Range

2. Right click and then click Format Cells.

3. Select Custom.

4. In the Type box press Alt + Numpad 7 to insert a bullet point (or copy/paste a bullet point) enter a space and type @

5. Click OK.

Custom Number Format

6. You can now create a bulleted list by simply typing the list items. Excel automatically adds the bullet points!

Bulleted List in Excel

Note: use the Format Painter to quickly copy the bullet point format to a different section on your worksheet.

CHAR function

You can also use the CHAR function to add bullet points in Excel.

1. The formula =CHAR(149) adds a bullet point to a cell.

CHAR function

2. Use the & operator to concatenate the CHAR function with text to create a bulleted list.

Add Bullet Points in Excel

Tip: to quickly convert this bulleted list which consists of formulas into a range with static values check out the trick explained on this page (step 4).

Leave A Comment

Excel meets AI – Boost your productivity like never before!

At Formulas HQ, we’ve harnessed the brilliance of AI to turbocharge your Spreadsheet mastery. Say goodbye to the days of grappling with complex formulas, VBA code, and scripts. We’re here to make your work smarter, not harder.

Related Articles

The Latest on Formulas HQ Blog