Excel guide · 5 min read
How to add bullet points in Excel
Sample data
Every result on this page was calculated from this sheet by the same spreadsheet engine the Cellwise app uses.
| Row | A | B | C | D | E | F |
|---|---|---|---|---|---|---|
| 1 | Task | Owner | With bullet | Pasted from Word | Cleaned | |
| 2 | Book venue | Priya | • Book venue | • Parking passes | Parking passes | |
| 3 | Send invites | Tom | • Send invites | • Name cards | Name cards | |
| 4 | Order catering | Priya | • Order catering | • Spare HDMI cable | Spare HDMI cable | |
| 5 | Print badges | Sam | • Print badges | • Water for speakers | Water for speakers | |
| 6 | Test the projector | Tom | • Test the projector | |||
| 7 | Collect feedback | Sam | • Collect feedback |
Download this sheet as an Excel practice file (.xlsx)
Which method to pick
It depends on whether the bullet is decoration or part of the data:
- A few bullets in a note or a header: type them with Alt+7 or Insert > Symbol.
- A whole column that should look like a list: use the custom number format. The cells still hold plain text, so sorting, filtering and lookups ignore the bullet.
- A list built from other cells, or several bullets in one cell for a report: use a formula with "• "&.
- Real indents and sub-bullets, like a slide: use a text box, where Excel has proper Bullets.
Method 1: type a bullet with Alt+7 or Alt+0149
This is the quickest way on a Windows keyboard with a number pad. The digits must come from the number pad, not the row above the letters, and Num Lock must be on.
On a Mac, Option+8 types • on the standard US keyboard layout.
- Double-click the cell, or select it and press F2, so you're typing inside it.
- Hold Alt, press 7 on the number pad, release Alt. A • appears. Alt+0149 gives the same character.
- Type a space and your text.
- For a second bullet in the same cell, press Alt+Enter to start a new line and repeat.
Method 2: Insert > Symbol (no number pad needed)
Laptops often have no number pad, and Alt+7 does nothing there. The Symbol dialog works on any keyboard, and once you've used it the bullet sits in its Recently used symbols row.
- Select a blank cell, or double-click into a cell where the bullet should go.
- Go to Insert > Symbol (in the Symbols group).
- Type 2022 in the Character code box at the bottom. That's the bullet •.
- Click Insert, then Close.
- If your font has no bullet, pick Wingdings in the Font box and use character code 159.
Can I copy a bulleted list from Word?
Yes. Pasted normally, each bullet lands in its own cell, usually without the bullet. To keep the whole list in one cell, double-click the cell first and then paste.
Method 3: a custom number format that adds the bullet
If you want every item in a column to show a bullet, don't type 50 of them. A custom number format adds the bullet to the display and leaves the value alone, so a lookup for Book venue still finds Book venue. Type the bullet once into the format code with Alt+7 or paste it.
- Select the cells, for example A2:A7.
- Press Ctrl+1 and go to the Number tab.
- Choose Custom and type "• "@ in the Type box. The @ stands for whatever text is in the cell, and the quotation marks hold the bullet and the space.
- Click OK. Every text entry now shows a bullet, including new ones you type.
Why don't my numbers get a bullet?
The @ part of a format only applies to text. Numbers in the same column show without the bullet. For a column of numbers use a code such as "• "0 instead.
Can I do this in Excel for the web?
Microsoft says custom number formats can't be created in Excel for the web. Open the file in the desktop app to add the format; it then displays in the browser too.
Method 4: add bullets with a formula
When the list comes from other cells, join the bullet on with &. Column C of the sample does this for every task. Paste the • into the formula, or on Windows use CHAR(149), which returns the same character there. Mac Excel uses a different character set for CHAR, so the pasted character is the safer choice in a shared file.
Result: • Book venue
• Book venue: the bullet, a space and the task name. Fill it down and every row gets one.
How do I put a whole bulleted list in one cell?
Join the items with a line break, CHAR(10), and turn on Home > Wrap Text for the cell so the breaks show. TEXTJOIN needs Excel 2019 or later; in Excel 2019 you may need to confirm with Ctrl+Shift+Enter.
Result: • Book venue • Send invites • Order catering • Print badges • Test the projector • Collect feedback
Six lines in one cell, from • Book venue down to • Collect feedback. The TRUE skips blank rows, so the list grows cleanly if you extend the range.
Remove bullets you didn't want
Lists pasted from Word, email or a web page often arrive with the bullet typed into the text. Column E of the sample is like that. A typed bullet breaks lookups and sorting, because "• Name cards" isn't "Name cards".
For a one-off clean-up, select the column, press Ctrl+H, put • and a space in Find what, leave Replace with empty and click Replace All. For a formula that keeps the original, use SUBSTITUTE.
Result: Parking passes
Parking passes: the bullet and the space after it removed. Copy the cleaned column and use Paste Special > Values if you want to replace the original.
Real indents: use a text box
Cells can't hang an indent under a bullet, so long wrapped items line up badly. For a block of notes on a dashboard, insert a text box (Insert > Text Box), type the list, select the text, right-click and choose Bullets. You get proper indents, sub-levels with Tab and numbered lists. The trade-off: a text box floats over the sheet, so it doesn't sort, filter or move with rows. SmartArt (Insert > SmartArt) is the other option when the list is really a diagram.
Common mistakes
Pressing Alt+7 with the digit keys above the letters
Alt codes need the number pad with Num Lock on. Without one, use Insert > Symbol and code 2022.
Typing a bullet into every cell of a data column
Use the custom format "• "@ so the value stays clean for lookups and sorting.
Line breaks that don't show in a TEXTJOIN list
Turn on Wrap Text for that cell. CHAR(10) is there, it just isn't displayed without it.
Using CHAR(149) in a file Mac users open
Paste the • character into the formula instead; CHAR depends on the system character set.
FAQ
What is the shortcut for bullet points in Excel?
On Windows, Alt+7 or Alt+0149 on the number pad types •. On a Mac, Option+8 does it on the US layout. There's no ribbon button for bullets in cells.
How do I add bullet points in one Excel cell?
Double-click the cell, type a bullet and the first item, press Alt+Enter for a new line and repeat. Wrap Text must be on for the lines to show.
How do I add bullets to a whole column in Excel?
Select the column, press Ctrl+1, choose Custom and type "• "@. Every text entry shows a bullet without changing the value.
Why is there no bullet button in Excel?
Cells hold values, not paragraphs, so Excel only offers bullets inside text boxes and shapes. In cells you type the • character or use a number format.
How do I remove bullet points in Excel?
Use Ctrl+H to replace "• " with nothing, or =SUBSTITUTE(A2,"• ","") in a helper column. If the bullet comes from a number format, set the cells back to General.
Functions used
Related guides
- How to indent text in Excel
- Combine cells with a line break in Excel
- How to combine text with numbers and dates in Excel
- How to insert a check mark in Excel
- How to insert the degree symbol in Excel
- How to concatenate with a space in Excel (CONCAT and &)
Updated