# How to Add Bullet Points in Excel (Step by Step)

Excel has no bullet button on the ribbon, so you build bullets yourself. You can type one with a keyboard shortcut, generate one with a formula, or apply a custom number format that shows a bullet in front of every value in a range. This guide shows how to add bullet points in Excel three ways, with the exact keystrokes and formulas for each.

## Quick Answer

- **Type a bullet directly:** if your keyboard has a numeric keypad, hold Alt and press 7 on the keypad [1].
- **Insert any symbol:** go to Insert > Symbol, type 2022 in the Character code box, click Insert, then Close [1].
- **Build one with a formula:** `=CHAR(149)&" "&A2` prefixes the text in A2 with a bullet character and a space.
- **Add a second line in the same cell:** press Alt+Enter to start a new line, then repeat the bullet [1].
- **Apply to a whole range:** use a custom number format so the bullet appears without changing the underlying value.

## Before You Start

Two things decide which method works for you.

First, check your keyboard. The Alt+7 shortcut only works on the numeric keypad on the right side of a full-size keyboard. On a laptop without a keypad, use the Symbol dialog or a formula instead [1].

Second, decide whether the bullet should be part of the cell's text or just part of how the cell looks. If you type a bullet, it becomes a character in the value. That matters later when you sort, filter, or match text, because the bullet travels with the string. A custom number format keeps the underlying value clean and only changes the display.

You also need to know how to edit inside a cell. Double-click the cell, or select it and press F2, to place the cursor in the text. Pressing Enter while editing commits the value and moves down. Pressing Alt+Enter inserts a line break inside the cell instead [1].

## Step by Step

### Method 1: Type a bullet with the keyboard

1. Double-click the cell where you want the bullet, or select it and press F2.
2. If you have a numeric keypad, hold Alt and press 7. A bullet appears at the cursor [1].
3. Type a space, then your text.
4. Press Enter to commit the value.

### Method 2: Insert a bullet from the Symbol dialog

1. Select a blank cell.
2. On the Insert tab, in the Symbols group, click Symbol [1].
3. At the bottom of the dialog, type 2022 in the Character code box [1].
4. Click Insert, then click Close [1].
5. Type a space and your text after the bullet.
6. If you need another bullet on a new line underneath, press Alt+Enter and repeat the process [1].

### Method 3: Generate bullets with a formula

1. Put your plain text in one column, for example A2:A7.
2. In B2, enter `=CHAR(149)&" "&A2`.
3. Press Enter. The cell shows a bullet, a space, then the text from A2.
4. Select B2, grab the fill handle, and drag down to B7.
5. If you want to keep only the text, copy column B and paste as values.

The ampersand joins the bullet character, a space, and the cell reference into one string. The space matters. Without it, the bullet sits flush against the first letter.

### Method 4: Use a custom number format

1. Select the cells you want to format.
2. Press Ctrl+1 to open Format Cells.
3. Go to the Number tab and choose Custom.
4. In the Type box, enter a bullet character followed by a space and an `@` symbol. The `@` stands for the cell's existing text.
5. Click OK.

Every value in the selected range now displays with a bullet in front, while the stored value stays unchanged.

## Worked Example

The table below is a simple task list. Column A holds the plain task names. Column B prefixes each one with a bullet character using `CHAR(149)` and a space. Column C shows the same formula applied to the same source text.

| Row | A (Task) | B (Bullet Text) | C (Bullet + Task) |
|-----|----------|-----------------|-------------------|
| 1 | Task | Bullet Text | Bullet + Task |
| 2 | Buy groceries | `=CHAR(149)&" "&A2` -> displays • Buy groceries | `=CHAR(149)&" "&A2` -> displays • Buy groceries |
| 3 | Call dentist | `=CHAR(149)&" "&A3` -> displays • Call dentist | `=CHAR(149)&" "&A3` -> displays • Call dentist |
| 4 | Finish report | `=CHAR(149)&" "&A4` -> displays • Finish report | `=CHAR(149)&" "&A4` -> displays • Finish report |
| 5 | Pay bills | `=CHAR(149)&" "&A5` -> displays • Pay bills | `=CHAR(149)&" "&A5` -> displays • Pay bills |
| 6 | Schedule meeting | `=CHAR(149)&" "&A6` -> displays • Schedule meeting | `=CHAR(149)&" "&A6` -> displays • Schedule meeting |
| 7 | Water plants | `=CHAR(149)&" "&A7` -> displays • Water plants | `=CHAR(149)&" "&A7` -> displays • Water plants |

Each formula does one job: it prefixes the task in column A with a bullet character and a space. The result is a single text string, so the bullet and the task can no longer be separated by sorting or filtering. If you need the bullet to stay attached to the text, this is the right approach. If you need the underlying value to stay clean, use the custom number format instead.

The character that `CHAR(149)` returns depends on the platform's character set. Excel for Windows returns a bullet (•), but Excel for Mac uses the Mac character set, where code 149 is ï. For a bullet on any platform, use `=UNICHAR(8226)&" "&A2` instead (Excel 2013 and later).

## Other Ways to Do It

**Copy and paste from Word.** You can copy a bulleted list from another program like Word. By default, Excel puts each bullet in its own cell. If you double-click a cell and paste the whole list, the entire list lands inside that one cell [1].

**Bullets in a text box or shape.** If you are using text in a shape or text box, right-click the text and select the Bullets option [1].

**Use a helper column and concatenation.** If your text lives in one column and you want bullets in another, the CHAR formula is the cleanest route. It keeps the original text intact so you can still sort and filter on it. This pairs well with other text-building formulas, and the same concatenation logic shows up in guides like [how to make a formula in Excel](/blog/data-analysis/how-to-make-formula-in-excel).

**Format a whole checklist at once.** If you are building a task list, a bullet format plus a checkbox column gives you a usable tracker. See [how to add a checkbox in Excel](/blog/data-analysis/how-to-add-checkbox-in-excel) for the checkbox side.

**Combine bullets with a dropdown.** If your bulleted items come from a fixed list, a dropdown keeps the entries consistent. The steps are in [how to create a drop down list in Excel](/blog/data-analysis/how-to-create-drop-down-excel).

## Troubleshooting

**The bullet shows as a box or a strange character.** The font does not support that character code. Select the cell, open the Symbol dialog, choose a font such as Wingdings, and enter character code 159 [1]. Or switch the cell to a font that includes the bullet glyph.

**Alt+7 does nothing.** You are probably pressing the 7 above the letters, not the one on the numeric keypad. The shortcut needs the keypad [1].

**I cannot start a new line inside the cell.** Press Alt+Enter while the cursor is in the cell. If that does nothing, make sure you are in edit mode first by double-clicking the cell or pressing F2 [1].

**The formula returns an error.** Check that the cell reference exists and that you used straight quotation marks around the space. Curly quotes from a word processor will break the formula.

**The bullet disappears after I sort.** If you typed the bullet as part of the text, it stays with the text. If you used a custom number format, the bullet is display only and follows the cell, not the value. Decide which behavior you want before you build the list.

## Common Mistakes

- **Forgetting the space after the bullet.** `=CHAR(149)&A2` produces a bullet jammed against the first letter. Use `=CHAR(149)&" "&A2` so the text is readable.
- **Using the wrong CHAR code.** Different fonts map characters differently. If `CHAR(149)` looks wrong, try the Symbol dialog with code 2022 or a Wingdings font with code 159 [1].
- **Typing bullets into data you plan to sort or match.** The bullet becomes part of the string, so `"Buy groceries"` and `"• Buy groceries"` are different values. Keep a clean column and a bulleted column if you need both.
- **Pressing Enter instead of Alt+Enter for a second bullet.** Enter commits the cell and moves down. Alt+Enter adds the line break you need [1].
- **Pasting a Word list into one cell by accident.** A normal paste spreads the list across cells. Double-click the cell first if you want the whole list in one cell [1].
- **Applying a custom format to numbers.** The `@` symbol only stands for text. If the cell holds a number, the format needs a numeric section instead, or the bullet will not appear as expected.

## Limitations

Bullets in Excel are cosmetic text, not list structure. Excel has no built-in bulleted list object inside a cell, so a bullet is just a character you place in front of your text. That means you cannot indent wrapped lines the way Word does, and a long bulleted entry wraps back to the left edge of the cell instead of aligning under the text.

The character codes are also font dependent. A code that renders as a clean round bullet in one font may render as a box or a different glyph in another, and the same workbook can look different on a machine with different fonts installed. If the file will be shared widely, test it on another computer before you rely on it. For anything longer than a short list, a word processor or a dedicated list tool will give you better control over spacing and indentation.

## Frequently Asked Questions

### How do I add a bullet point in Excel without a numeric keypad?

Use the Symbol dialog. Select a blank cell, go to Insert > Symbol, type 2022 in the Character code box, click Insert, then Close [1]. You can also use a formula like `=CHAR(149)&" "&A2` to generate the bullet automatically.

### How do I put multiple bullet points in one cell?

Type the first bullet and its text, press Alt+Enter to start a new line inside the same cell, then add the next bullet [1]. Repeat for each item. The cell grows taller as you add lines, so you may want to turn on Wrap Text and widen the row.

### Why does my bullet show as a box?

The font assigned to the cell does not include that character. Open the Symbol dialog, pick a font such as Wingdings, and enter character code 159 [1]. Or change the cell font to one that supports the bullet glyph.

### Can I add bullets to a whole column at once?

Yes. Use a custom number format with a bullet character and the `@` symbol, applied to the whole range. The bullet appears in front of every text value while the stored values stay unchanged. This is faster than typing a bullet into each cell.

### Do bullets affect sorting and filtering?

Only if the bullet is part of the cell's text. A typed bullet or a CHAR formula makes the bullet part of the value, so it sorts and filters along with the text. A custom number format changes only the display, so sorting and filtering ignore the bullet.

## References

1. [Insert bullets in a worksheet | Microsoft Support](https://support.microsoft.com/en-us/excel/insert-bullets-in-a-worksheet)

## Further Reading

- [Broman KW, Woo KH (2018). Data Organization in Spreadsheets. The American Statistician](https://doi.org/10.1080/00031305.2017.1375989)
- [Ziemann M, Eren Y, El-Osta A (2016). Gene name errors are widespread in the scientific literature. Genome Biology](https://doi.org/10.1186/s13059-016-1044-7)
- [Microsoft Support: Excel help and learning](https://support.microsoft.com/en-us/excel)
- [McCullough B, Heiser DA (2008). On the accuracy of statistical procedures in Microsoft Excel 2007. Computational Statistics & Data Analysis](https://doi.org/10.1016/j.csda.2008.03.004)
- [Abeysooriya M, Soria M, Kasu MS et al. (2021). Gene name errors: Lessons not learned. PLOS Computational Biology](https://doi.org/10.1371/journal.pcbi.1008984)

## Related Articles

- [How to Add a Checkbox in Excel (Step by Step)](/blog/data-analysis/how-to-add-checkbox-in-excel)
- [How to Add Multiple Rows in Excel (Step by Step)](/blog/data-analysis/how-to-add-multiple-rows-in-excel)
- [How to Make a Line Chart in Excel (Step by Step)](/blog/data-analysis/how-to-make-line-chart-excel)
- [How to Make a Formula in Excel (Step by Step)](/blog/data-analysis/how-to-make-formula-in-excel)
- [How to Make a Chart in Excel (Step by Step)](/blog/data-analysis/how-to-make-chart-in-excel)