How to Insert Bullet Points in Excel

To insert a bullet point in an Excel cell on Windows, select the cell, press Alt+0149 using the numeric keypad, release Alt, and type your text. On a Mac, press Option+8. You can also insert a bullet from the Symbol dialog or copy and paste one. Excel does not have a built-in bulleted-list button like Word, so bullets are characters you place in cells.

What You’ll Need

Excel for Microsoft 365 on Windows, or Excel for Mac if you are following the Mac notes. The steps also work in many earlier desktop versions.
A cell where you can enter or edit text. If you want several bullets in one cell, turn on Wrap Text so the lines display properly.
For the Windows Alt code, a numeric keypad is the most reliable option. If your keyboard has no separate keypad, use the Symbol method or copy and paste a bullet instead.

Step-by-Step

Insert a bullet with the Windows keyboard shortcut. Double-click a cell, or select it and press F2, to edit its contents. Place the cursor where the bullet should appear. Hold down Alt, type 0149 on the numeric keypad, then release Alt. Excel should show a solid bullet character, •. Type a space after it, then enter the item text. Press Enter to finish. The code uses the numeric keypad, not the number row above the letters; typing 0149 on that number row usually will not insert the bullet. If the code does not work, check that Num Lock is on and try the Symbol method below.
Use the Mac shortcut. In Excel for Mac, select a cell and press Control+U or double-click it to edit, then press Option+8 to type a bullet. Add a space and the text. Keyboard layouts and regional settings can affect the character produced by shortcuts, so confirm that you see •. If not, open the macOS character viewer or use copy and paste. Do not use the Windows Alt code on a Mac; it is not the equivalent shortcut.
Insert a bullet from Excel’s Symbol dialog. Select the cell and start editing it, then place the cursor at the insertion point. On the Windows desktop ribbon, choose Insert > Symbol (in the Symbols group). In the dialog, select a font such as Arial or Calibri and locate the solid bullet, often shown as •. Select it, choose Insert, and close the dialog. Type a space and your text. The dialog may remember the last symbol used, but check the displayed character before inserting it. On Mac, use the Insert tab’s symbol options if available in your Excel build, or use Option+8 or copy and paste.
Copy and paste a bullet when you need a quick option. Copy this character: •. Double-click the destination cell, click where the bullet belongs, and paste it; then type a space and the wording. You can also copy a bullet from an existing cell. This is convenient on a laptop without a numeric keypad, in Excel for the web, or when a keyboard layout makes shortcuts awkward. Copy only the symbol if you do not want to bring along formatting from the source. If the pasted character looks different, use a common font such as Arial or Calibri.
Put several bullet lines in one cell. Enter the first bullet and its text, then insert a line break without leaving the cell. On Windows, press Alt+Enter; on Mac, press Control+Option+Return in Excel for Mac. Insert another bullet at the new line using the appropriate shortcut, Symbol dialog, or a pasted character, then type the next item. Repeat for each line. Choose Home > Wrap Text so the lines are visible. A line break stays inside one cell; pressing Enter by itself normally commits the cell and moves the selection to another cell.
Add bullets to separate cells in a column. Put one bullet and its text in each cell, rather than creating line breaks inside a single cell. For the first cell, enter the bullet, a space, and the first item. Select that cell, copy it, then paste into the cells below and replace each item’s wording. This carries the bullet character with the text. If you copy the whole cell, it may also copy its formatting; use Paste Special or paste the symbol alone if you want to preserve the destination cells’ existing formats.
Adjust the display after entering the text. Select the cell or range and choose Home > Wrap Text if the wording is cut off or spans multiple lines. Widen the column, increase the row height, or use Home > Format > AutoFit Row Height to reveal the contents. To create space between the bullet and the words, type a normal space after the bullet. For a hanging-indent look, use the cell’s alignment and indentation controls, or adjust the column width; Excel does not provide Word’s full paragraph-bullet controls for individual lines in a cell.

To edit a bullet later, select the cell and press F2 on Windows, or double-click the cell. Place the cursor beside the character and use Backspace or Delete as needed. If the cell contains several lines, click within the line you want to change before editing; replacing the entire cell contents by mistake is easy when you type without entering edit mode.

Common Mistakes

Typing the Alt code on the wrong keys. The Windows Alt+0149 code generally requires the numeric keypad. The top number row is not a substitute. Some compact keyboards use a built-in keypad layer activated by an Fn key, but the key combination varies by device.
Pressing Enter while intending a new line. Enter normally confirms the cell entry. Use Alt+Enter on Windows to make a line break within the same cell, then insert the next bullet.
Expecting a whole range to become a bulleted list automatically. Excel stores bullets as characters in cell content; it does not apply a list style to a selected range like a word processor. Add or paste a bullet in each cell that needs one.
Forgetting a space after the bullet. Without a space, the text touches the symbol and can be harder to scan. Type a regular space after each bullet unless you have deliberately used another spacing method.
Assuming the bullet disappeared because it is not visible. A narrow column, small row height, or disabled Wrap Text can hide part of the entry. Check the formula bar or edit the cell before retyping; the character may still be there.
Using a font that does not display the symbol well. A pasted bullet can appear as a box or a different mark if the selected font lacks that glyph. Try Arial or Calibri and check the result in the cell.

Tips

Keep the symbol consistent. Use the same solid bullet character throughout a worksheet. Mixing solid bullets, hollow circles, hyphens, and decorative symbols can make related lists look disorganized.
Choose the cell layout to match the job. Use one bullet per row when readers need to sort, filter, or refer to individual items. Put multiple lines in one cell when the list is a single note or description. A single cell containing several line breaks is harder to sort as separate items.
Use a blank cell as a reusable source. Store a bullet by itself in a convenient cell, then copy just that character into other entries. This avoids looking up a shortcut each time and works across different keyboard layouts.
Keep the bullet and wording together. When a bullet list is part of a longer entry, use a normal space after the symbol and avoid putting the bullet in a neighboring cell unless you want the symbol and wording to sort or format separately.
Check the result at normal viewing size. A bullet can look fine while editing but become cramped when the column is narrow or the sheet is printed. Preview the worksheet and adjust the column width, row height, or font size as needed.
Use a simple character for compatibility. The standard bullet • is widely supported. Decorative symbols may not display the same way on another computer, in a different font, or after exporting the workbook.

Troubleshooting

The Alt code inserts nothing. Make sure the cell is in edit mode, hold Alt while entering all four digits on the numeric keypad, and release Alt after the last digit. Turn on Num Lock if your keyboard has it. Laptop keypad layers differ, so if you are unsure which keys act as the keypad, use Insert > Symbol or paste •.

I get the wrong character. The character can depend on the keyboard layout, code-page behavior, or font. Delete the unintended character and insert the bullet through the Symbol dialog, or copy the standard bullet shown in this guide. Confirm the font is a standard one such as Arial or Calibri.

The next bullet starts in another cell. You likely pressed Enter, which ended editing. Select the cell again, press F2 or double-click, move the cursor to the end of the first line, and use Alt+Enter on Windows. Then add the next bullet. On Mac, use Control+Option+Return for an in-cell line break.

The text or later lines are cut off. Select the affected cells and choose Home > Wrap Text. Then increase row height or use Home > Format > AutoFit Row Height. If a row has a manually fixed height, AutoFit may not fully reveal its contents; drag the row boundary to increase the height.

The bullet is visible in the formula bar but not in the cell. Widen the column, check the font color and size, and confirm that the cell is not displaying a number format or other styling that obscures the text. If necessary, select the cell and choose Home > Clear > Clear Formats, then apply the desired formatting again. Be careful: clearing formats removes existing visual formatting from the selected cells.

The shortcut differs in Excel for the web. Browser and operating-system shortcuts can conflict, and the desktop Symbol dialog may not be available in the same form. Use copy and paste for the bullet character, or type it in a desktop version of Excel and open the workbook in the browser. If editing on a Mac, use the Mac shortcut rather than the Windows Alt code.

Frequently Asked Questions

Can Excel create a bulleted list automatically?
Not with a dedicated bulleted-list button like Word. Insert a bullet character in each cell or line yourself. Excel’s cell entries can contain symbols and line breaks, but they are not Word-style list objects.

Can I put more than one bullet in the same cell?
Yes. Enter a bullet and text, press Alt+Enter on Windows to make a new line in the cell, then add the next bullet and text. Turn on Wrap Text to show the full list.

What is the Windows shortcut for a bullet in Excel?
Hold Alt and type 0149 on the numeric keypad, then release Alt. If your keyboard has no numeric keypad or the code does not work, insert the symbol from the ribbon or copy and paste it.

How do I type a bullet in Excel for Mac?
Press Option+8 while editing a cell. The exact result can depend on your keyboard layout. If it does not produce a solid bullet, use the macOS character viewer or copy and paste the symbol.

Can I sort or filter cells that contain bullets?
Yes. Excel treats the bullet as part of the cell’s text, so cells can still be sorted and filtered. If each list item needs to be managed separately, put each item in its own row rather than storing several items as line breaks in one cell.

Will the bullets print or appear in another spreadsheet app?
Usually, a standard bullet character displays and prints normally, but appearance can vary with fonts and software. Check Print Preview and use a common font if the workbook will be opened on other devices or exported.

Try it: the Date Difference Calculator: days, months, years and weekdays between two dates, with the DATEDIF formulas.

More in How-to basics

Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources

Spotted an error in this guide? Let us know.