Multiple bullet points in excel cell

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.

2.

How to add bullet points in excel shortcut

How to add bullet points in excel shortcut

Multiple bullet points in excel cell mac

How to insert bullet points in word

How to add bullet points in google sheets

How to add bullet points in powerpoint

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

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.

2.

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

Result:

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

Custom Number Format

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

1.

How to align bullet points in excel

Select the range A1:A3.

2. Right click, and then click Format Cells.

3. Select Custom.

4.

how to do bullet points in excel in one cell

how to do bullet points in excel text box