How To Insert Bullets in Excel

Excel has no Bullets button. Microsoft Word puts one right on the Home tab, Excel never has, and that is why a job that should take two seconds sends people looking for a tutorial.

Answer: To add a bullet point inside an Excel cell, press Alt + 7 on the numeric keypad, or Option + 8 on a Mac, then type your text. For several bullets in one cell, press Alt + Enter between each line and switch on Wrap Text from the Home tab.

Last updated: August 19, 2026

What this guide covers:

• How do you put multiple bullet points in one Excel cell?
• What is the bullet point shortcut in Excel on Windows and Mac?
• What if your laptop has no numeric keypad?
• How do you insert a bullet from the Symbol menu?
• How do you add bullets with the CHAR and UNICHAR functions?
• How do you bullet an entire column automatically?
• How do you make a properly indented bulleted list?
• How do you remove bullet points in Excel?
• Why are my bullet points not working?
• Frequently asked questions about bullet points in Excel

How do you put multiple bullet points in one Excel cell?

This is what most people actually want, and it needs two things working together, not one. The bullet character gives you the dot. A line break gives you the list. Miss the second and everything runs together on one line.

1. Double-click the cell to get into edit mode.
2. Press Alt + 7 on the numeric keypad to drop in a bullet (•), then a space, then type the first item.
3. Press Alt + Enter. This inserts a line break inside the cell rather than moving to the cell below.
4. Press Alt + 7 again and type the next item. Repeat for each line.
5. Press Enter when you are done.
6. With the cell still selected, go to Home and click Wrap Text in the Alignment group.

If the cell now shows only the first line, the row height is fixed. Select the row, then Home, Format, AutoFit Row Height.

Alt + Enter creates the line break. Wrap Text makes the break visible. Doing one without the other is the single most common reason an in-cell bullet list looks broken.

Microsoft covers the line break itself in its note on starting a new line of text inside a cell. On a Mac the line break is Control + Option + Return.

One thing to decide before you build a sheet this way. A cell holding five bulleted lines is one value to Excel, so you cannot sort, filter, count, or look up the individual items. If the items are data rather than a note, give each one its own row and bullet the column instead, which is covered further down.

What is the bullet point shortcut in Excel on Windows and Mac?

Alt codes only fire on the numeric keypad. The number row above the letters will type a plain 7 no matter how long you hold Alt.

Num Lock also has to be on. If it is off, the keypad sends arrow keys instead of digits and the shortcut silently does nothing.

What if your laptop has no numeric keypad?

Most laptops under 15 inches ship without one, which quietly kills the Alt + 7 method for a large share of readers. Four alternatives, fastest first.

• Type it once, then copy it. Put a bullet in a spare cell using any method below, then copy it and paste it wherever you need. For repeat use, put it in AutoCorrect: File, Options, Proofing, AutoCorrect Options, and set a trigger such as bb to replace with •. Typing bb then space now gives you a bullet anywhere in Office.
• Use the formula. =UNICHAR(8226) returns a bullet with no keypad involved.
• Use the Symbol dialog. Insert, Symbol, covered in the next section.
• Use the on-screen keyboard or Fn overlay. Many laptops map a keypad onto the U, I, O, J, K, L keys behind an Fn or NumLock toggle. Hold Fn, turn on Num Lock, and Alt + 7 works using the overlay keys.

The AutoCorrect route is the one worth setting up. It takes thirty seconds once and then follows you into every workbook and every Office app on that machine.

How do you insert a bullet from the Symbol menu?

The Symbol dialog gives you the widest choice of bullet styles and needs no shortcut at all.

1. Select the cell: click the cell, then double-click to enter edit mode so the symbol lands inside the text rather than replacing it.

2. Go to the Insert tab at the top of the Excel window.

3. Choose the symbol option: in the Symbols group at the far right, click Symbol.

   

4. Select a bullet symbol: for the standard round bullet, set Font to (normal text), set Subset to General Punctuation, and type 2022 into the Character code box with "from" set to Unicode (hex). For heavier or decorative bullets, switch Font to Wingdings or Wingdings 2. Useful codes:

   • • Round bullet, normal text, code 2022

   • ▪ Square bullet, normal text, code 25AA

   • ➤ Arrow bullet, Wingdings, code 216

5. Insert the symbol: click Insert, then Close. The bullet appears in the cell.

   

6. Add more bullets: press Alt + Enter for a new line inside the cell, then repeat. Faster still, copy the first bullet and paste it.

A Wingdings bullet is only a bullet while the cell uses the Wingdings font. Change the font later and it turns into a random letter, so use the normal text bullet for anything you will hand to somebody else.

How do you add bullets with the CHAR and UNICHAR functions?

Use a formula when the bullet needs to appear next to text that already lives in another cell, or when you want the whole column built automatically.

1. What the functions do: CHAR returns a character from a numeric code, and code 149 is the bullet. Type =CHAR(149) and press Enter to get •. UNICHAR does the same thing from a Unicode number, so =UNICHAR(8226) gives the same bullet and behaves more predictably across Windows and Mac. Prefer UNICHAR if you have Excel 2013 or later.

2. Bulleting text from another cell: join the bullet to your text with the ampersand operator. If your task sits in A2, use =UNICHAR(8226) & " " & A2. Fill that down column B and every row gets a bullet.

3. Several bullets in one cell from a formula: CHAR(10) is the line break character. Chain the parts together like this:

=UNICHAR(8226) & " Task 1" & CHAR(10) & UNICHAR(8226) & " Task 2"

The result will look like one long line until you switch on Wrap Text for that cell. This is the step people miss. CHAR(10) inserts the break into the value, but Excel only renders it when the cell is set to wrap. Do not press Alt + Enter here, because inside a formula cell that breaks the formula rather than the display.

Formula bullets are part of the result, not the source. Sort or look up the original column and it is still clean, which is the advantage of building the bullet in a second column rather than typing it into the first.

If you later want the bulleted text as real values, copy the formula column and use Paste Special, Values.

How do you bullet an entire column automatically?

A custom number format puts a bullet in front of every cell in a column without touching a single cell value. VLOOKUP, sorting, filtering, and COUNTIF all keep working on the raw text, because the bullet exists only in the display layer.

1. Select the column or range.
2. Press Ctrl + 1 to open Format Cells, go to the Number tab, and choose Custom.
3. In the Type box, enter this, pasting a bullet character in place of the one shown:

"• "@

The quotes hold the literal bullet and a space. The @ is the placeholder for whatever text the cell contains. Click OK and the whole range is bulleted.

That code covers text only. If the range mixes text and numbers, use the four-part version so numbers get bullets too:

"• "General;"• "-General;"• "0;"• "@

This is the method to use for a list you will sort, filter, or reference in formulas. The cell still contains "Send invoice", not "• Send invoice", so nothing downstream breaks.

To get the bullet into the Type box, copy one from a cell and paste it, since Alt codes are unreliable inside dialog boxes.

Only bullet the cells that meet a condition

To bullet rows selectively, for example only the tasks that are not blank, wrap the same number format in a conditional formatting rule.

1. Select the range you want the rule to govern.

2. Open Conditional Formatting: go to Home, click Conditional Formatting, then New Rule.

3. Choose a rule type: pick "Use a formula to determine which cells to format".

4. Enter the formula: write it against the top-left cell of your selection. To bullet every non-empty cell starting at A1, use =A1<>"".

5. Apply the custom number format: click Format, go to the Number tab, choose Custom, and enter "• "@ in the Type box.

6. Click OK twice. Bullets now appear and disappear on their own as cells are filled in and cleared.

How do you make a properly indented bulleted list?

Everything above puts a bullet character at the start of a line. None of it gives you a hanging indent, where a long item wraps and the second line lines up under the text rather than under the bullet. Cells cannot do that. A text box can.

1. Go to Insert, then Text, then Text Box, and drag out a box on the sheet.
2. Type your items, pressing Enter between each one.
3. Select all the text, right-click it, and choose Bullets, then pick a style.

You get real bullet formatting with proper indentation, and you can restyle the whole list in one click.

A text box floats above the grid. Its contents are not data, so nothing in it can be sorted, filtered, printed in a specific cell, or referenced by a formula.

Use it for instructions, notes, and legends. Never for anything you will need to analyse later.

How do you remove bullet points in Excel?

How you remove them depends entirely on how they got there.

• Typed as characters: press Ctrl + H, paste a bullet and a space into "Find what", leave "Replace with" empty, and click Replace All.
• From a custom number format: select the range, press Ctrl + 1, and set the Number category back to General. The text is untouched because it never held a bullet.
• From a CHAR or UNICHAR formula: the bullet lives in the formula, so edit or delete it. To keep the plain text, copy the column and use Paste Special, Values, then run the find and replace above.
• From conditional formatting: go to Home, Conditional Formatting, Clear Rules.
• In a text box: click the box border and press Delete, or select the text and untick Bullets.

Why are my bullet points not working?

What about bullet points in Google Sheets?

Google Sheets handles this differently, with its own shortcuts and its own limitations, so the steps above will not transfer cleanly. We keep that one separate rather than trying to cover both in a single guide. See how to insert bullet points in Google Sheets for the Sheets version.

Final thoughts on how to insert bullets in Excel

Pick the method by what the list is for, not by which is quickest. A note that a human will read is fine as bullets typed straight into a cell with Alt + 7 and Alt + Enter. A list you will sort, filter, or look up belongs in one row per item with a custom number format doing the bullets, so the underlying values stay clean. And anything that needs a real hanging indent belongs in a text box, where it stops being data and becomes decoration.

You can visit our homepage for more easy-to-follow how-to and step-by-step guides. Check the links in related articles for further details about Excel and Google Sheets templates.

Frequently asked questions about bullet points in Excel

Can I add multiple bullet points inside a single Excel cell?

Yes. Double-click into the cell, press Alt + 7 for a bullet, type the item, then press Alt + Enter to start a new line inside the same cell and repeat. When you are finished, switch on Wrap Text from the Home tab, otherwise the line breaks are stored but not displayed.

What is the keyboard shortcut for a bullet point in Excel?

On Windows it is Alt + 7 or Alt + 0149 using the numeric keypad, with Num Lock on. On a Mac it is Option + 8. Excel has no Bullets button on the ribbon, so a shortcut, the Symbol dialog, or a formula is the only way in.

Why does Alt + 7 not work on my laptop?

Because Alt codes only register on a numeric keypad, and most laptops under 15 inches do not have one. Use =UNICHAR(8226) in a cell, insert the bullet from Insert then Symbol, or create an AutoCorrect entry so typing something like bb becomes a bullet automatically.

How do I add bullet points to an entire column at once?

Select the column, press Ctrl + 1, go to Number, choose Custom, and enter the format code "bullet space"@ using a pasted bullet character. Every cell displays a bullet while the stored value stays unchanged, so sorting, filtering, and lookups continue to work normally.

How do I remove bullet points in Excel?

If the bullets were typed as characters, use Ctrl + H to find the bullet and a space and replace with nothing. If they came from a custom number format, set the Number category back to General. If they came from a formula, edit or delete the formula, using Paste Special Values first if you want to keep the text.

Is inserting bullet points in Google Sheets the same as Excel?

No. Google Sheets uses different shortcuts and behaves differently with in-cell line breaks and number formats, so the Excel steps do not carry across. See our separate guide to inserting bullet points in Google Sheets.

Related Articles

How to Capitalize in Excel

How to Undo Errors in Excel

How to Print Gridlines in Excel

How to Insert Bullet Points in Google Sheets