Excel doesn't have a built-in bullet button, but you can add bullets three ways

Excel treats bullets differently than Word does. There's no toolbar button that inserts a bullet, and pressing the bullet button in Word won't work inside a spreadsheet. Instead, you have three practical routes: type a bullet character directly, use the Format menu to create a custom list, or copy a bullet from another program and paste it into your cell. The fastest method for most people is typing the bullet character itself, which takes about five seconds per cell.

Which method you choose depends on how many cells need bullets and whether you want them to look a certain way. If you're adding bullets to just a few cells, typing the character is quickest. If you're formatting dozens of cells the same way, using a custom number format saves time and keeps everything consistent.

Key Takeaways

  • The simplest way to add a bullet is to type it directly: hold Alt and press 0149 on the number pad, then type your text.
  • You can also copy a bullet from Word or another program and paste it into your Excel cell, then add your text after it.
  • For multiple cells with the same format, create a custom number format using the Format Cells dialog so all bullets match automatically.
  • Bullets in Excel sit inside the cell itself, not in a separate list format, so they won't indent or auto-number like they do in Word.

Type a bullet character directly using Alt codes

The fastest way to add a single bullet is to type the bullet character itself. On Windows, hold down the Alt key and type 0149 on the number pad (the numeric keypad on the right side of your keyboard). Release Alt, and a bullet appears. On Mac, press Option and 8 together, then release both keys. A bullet will appear in your cell.

After the bullet appears, type a space and then your text. For example: Alt+0149, space, then "First item". Press Enter to move to the next cell. If you need bullets in multiple cells, repeat this for each one. This method works in any cell and doesn't require any menu navigation.

If your keyboard doesn't have a number pad (common on laptops), this method won't work. In that case, use one of the other approaches below.

Copy a bullet from Word and paste it into Excel

If you already have Word open or prefer not to memorize keyboard shortcuts, you can create a bullet in Word, copy it, and paste it into Excel. Open Word, type a bullet point (press Ctrl+Shift+L or go to Home > Bullets), then select just the bullet character itself. Copy it with Ctrl+C.

Switch to Excel, click the cell where you want the bullet, and paste with Ctrl+V. The bullet appears in your cell. Type a space and your text after it. You can now reuse this same bullet in other cells by pasting it again—you don't need to go back to Word each time.

This method is useful if you're already working in Word or if you want to match the exact bullet style from a Word document. It takes a few extra steps but requires no special knowledge of keyboard codes.

Create a custom number format for consistent bullets across multiple cells

If you're adding bullets to many cells and want them all to look identical, use a custom number format. This approach formats the cells automatically so you only type the text—the bullet appears on its own. Select all the cells that need bullets. Right-click and choose Format Cells, or press Ctrl+1.

In the Format Cells dialog, click the Number tab. On the left side, select Custom. In the Type field at the bottom, type this code: • "0" (that's a bullet character, a space, and the number zero in quotes). To insert the bullet character, use Alt+0149 on Windows or Option+8 on Mac, just as you would in a regular cell.

Click OK. Now type a number into any of those cells—just the number, nothing else. The cell will display the bullet, a space, and your number. This works best when your content is numbers or very short text. For longer text, the simpler methods above usually work better because the custom format approach can look cramped.

Why Excel bullets behave differently than Word bullets

In Word, bullets are part of a list structure that auto-indents, auto-numbers, and lets you nest items. In Excel, a bullet is just a character that sits inside a cell like any other letter or number. It won't indent, it won't auto-number the next cell, and it won't create a hierarchy.

This is because Excel is built for data in rows and columns, not for formatted documents. If you need real list formatting with indentation and nesting, Word or Google Docs is the better choice. But if you just need a visual marker to show that something is an item in a list, a bullet character in Excel works fine and takes seconds to set up.

Adjust cell height if your text wraps and the bullet gets cut off

When you type a bullet and text in a cell, and the text wraps to a second line, the bullet might disappear from view if the cell isn't tall enough. To fix this, double-click the border between two row numbers on the left side of the spreadsheet. Excel automatically adjusts the row height to fit all the text.

Alternatively, right-click the row number, select Row Height, and type a larger number. A height of 30 or 40 usually gives enough room for wrapped text with a visible bullet. You can also click and drag the border between row numbers to resize manually.

Frequently Asked Questions

Can I make a bulleted list that auto-numbers like in Word?

No. Excel doesn't have automatic list numbering. You can type bullets manually in each cell, or you can type numbers yourself (1, 2, 3) and add a bullet before each one. If you need true auto-numbering with nesting and indentation, Word or Google Docs is the right tool.

What if Alt+0149 doesn't work on my keyboard?

You likely don't have a dedicated number pad. Try copying a bullet from Word instead, or use the character map. On Windows, search for "Character Map" in the Start menu, find the bullet symbol, click it, click Copy, then paste it into Excel.

Can I use a different bullet style, like a square or diamond?

Yes. In the Character Map (Windows) or Special Characters (Mac), you can find dozens of bullet styles. Search for "bullet" or browse the Geometric Shapes section. Copy whichever style you want and paste it into Excel the same way you would a regular bullet.

Will my bullets print correctly?

Yes, bullets print the same way they appear on screen. If the bullet looks right in the cell, it will look right on paper. Test by printing a single page first to make sure the formatting matches what you expect.