Excel doesn't have a built-in bullet point feature, but you can add them using character codes, copy-paste, or formatting tricks

Excel treats everything you type as data first, not formatted text. If you want a bullet point to appear in a cell, you need to either type the bullet character itself, paste one from elsewhere, or use a workaround that looks like a bullet. The method you choose depends on whether you need bullets in a single cell, across multiple cells, or as part of a list within one cell.

The fastest route for most people is to copy a bullet character from somewhere else and paste it into Excel. If you need bullets regularly, you can also insert them using keyboard shortcuts or special character codes built into Windows or Mac.

Key Takeaways

  • You can type a bullet directly in Excel by holding Alt and pressing 0149 on the numeric keypad (Windows), or by copying a bullet from another program and pasting it into a cell.
  • To create a bulleted list within a single cell, type the bullet, add your text, press Alt+Enter to move to the next line, and repeat.
  • Mac users can type a bullet by holding Option and pressing 8, then add text and press Ctrl+Enter to create line breaks within the cell.
  • If you want bullets to appear automatically when you type a dash or asterisk, you can enable AutoCorrect in Excel's settings, though this only works in certain contexts.
  • Adjusting row height and enabling text wrapping will make multi-line bulleted lists readable in Excel cells.

Using the Alt Code to Type a Bullet on Windows

On a Windows computer, you can type a bullet character directly into any Excel cell using an Alt code. Hold down the Alt key, type 0149 on the numeric keypad (not the number row at the top of your keyboard), then release Alt. A bullet point will appear in the cell where your cursor is.

This works in any cell, and you can type text before or after the bullet. If you want a bullet followed by text, type the bullet first, add a space, then type your content. If you need multiple bullets in the same cell, press Alt+Enter after your first line to move to the next line within the cell, then repeat the Alt+0149 sequence and add your next item.

The numeric keypad is essential for this method — the number keys at the top of your keyboard will not work. If your laptop does not have a dedicated numeric keypad, you may need to enable Num Lock and use the number pad built into your keyboard, or use one of the other methods described below.

Using Option+8 on Mac to Insert a Bullet

Mac users can type a bullet by holding the Option key and pressing 8. This works in any Excel cell just like the Alt code does on Windows. Type the bullet, add a space, then type your text.

To create multiple bullets in the same cell on Mac, type your first bullet and text, then press Ctrl+Enter (not Return) to create a line break within the cell. This moves your cursor to the next line inside the same cell. Then type Option+8 again for the next bullet, add your text, and repeat as needed.

Copying and Pasting a Bullet from Another Source

If you do not want to memorize keyboard shortcuts, the simplest method is to copy a bullet from somewhere else and paste it into Excel. Open any text editor — Notepad, Word, Google Docs, or even an email — and type or find a bullet point. Select it, copy it (Ctrl+C on Windows or Cmd+C on Mac), then click into your Excel cell and paste (Ctrl+V or Cmd+V).

Once you have pasted one bullet into Excel, you can reuse it. Type the bullet, add a space, type your text, press Alt+Enter (Windows) or Ctrl+Enter (Mac) to move to the next line, then paste the bullet again. This method is slower than using keyboard shortcuts, but it requires no memorization and works on any computer.

Creating a Multi-Line Bulleted List Inside One Cell

Excel allows you to put multiple lines of text inside a single cell. To create a bulleted list this way, type your first bullet and text, then press Alt+Enter (Windows) or Ctrl+Enter (Mac) to move to the next line without leaving the cell. Type your next bullet and text, and repeat for each item.

After you have entered your bulleted list, you will likely need to adjust the row height so all the text is visible. Double-click the border between row numbers on the left side of the spreadsheet to auto-fit the row height, or drag the border down manually. You may also want to enable text wrapping: select the cell, go to the Home tab, click Wrap Text, and the text will automatically break to fit the cell width.

This approach keeps all your bullet points in one cell, which is useful if you want to group related information together or keep your spreadsheet compact. However, if you need to sort or filter your data, having multiple lines in one cell can make that harder.

Using AutoCorrect to Create Bullets Automatically

Excel has an AutoCorrect feature that can convert certain characters into bullets, though it works only in specific situations. If you type an asterisk or dash followed by a space at the start of a line, Excel may automatically convert it to a bullet. This feature is most reliable when you are working in a cell that already has text wrapping enabled.

To enable or adjust AutoCorrect settings, go to File, then Options, then Trust Center, then Trust Center Settings, then AutoCorrect Options. Look for the tab labeled AutoFormat As You Type and check the box for "Automatic bulleted lists." After you enable this, typing an asterisk or dash at the start of a line may trigger a bullet automatically.

This method is less reliable than typing bullets manually, and it does not work consistently across all versions of Excel or all cell types. If AutoCorrect does not seem to be working, fall back to one of the other methods above.

Formatting Bullets to Match Your Spreadsheet

Once you have added bullets to your cells, you can format them like any other text. Select the cells containing bullets, then use the font, size, color, and alignment tools in the Home tab to adjust their appearance. If your bullets are too small or hard to see, increase the font size. If you want them to stand out, change the font color or make them bold.

Keep in mind that bullets are just characters, so they follow the same formatting rules as regular text. If you make the entire cell bold, the bullet will be bold too. If you want only the bullet to be bold and the text to be regular, you will need to select just the bullet character and apply bold to it separately.

Frequently Asked Questions

Can I use bullet points in Excel formulas or functions?

No. Formulas work with data, not formatting. If you need a formula to display text with a bullet, you can concatenate a bullet character with text using the CONCATENATE function or the ampersand operator. For example, typing =CHAR(149)&" Your text here" will create a cell that displays a bullet followed by your text, but the bullet is part of the data, not a formatting choice.

Why do my bullets look different in Excel than they do in Word?

Excel and Word use different fonts and rendering systems. The bullet character you type in Excel may appear slightly different in size or style than a bullet in Word, even if you use the same font. This is normal and does not affect how the data works. If the appearance matters for printing or sharing, test how it looks before you finalize your spreadsheet.

Can I add bullets to a column header or title?

Yes. A bullet is just a character, so you can type it anywhere in Excel — headers, titles, regular cells, or anywhere else. Type the bullet using any of the methods above, add your header text, and format it as you would any other header.

What if the Alt+0149 code does not work on my keyboard?

Some keyboards, especially on laptops, do not have a dedicated numeric keypad. Try enabling Num Lock and using the number pad built into your keyboard, usually on the right side of the letter keys. If that does not work, copy and paste a bullet from another program instead, or use the CHAR function method described in the formula question above.