The simplest way to add bullet points in Excel

Excel does not have a built-in bullet point button like Word does. Instead, you add them by typing a special character, then your text. The fastest method is to type a bullet character directly into a cell, press Enter, and move on. On Windows, hold Alt and type 0149 on the numeric keypad to create a bullet. On Mac, hold Option and press 8. After the bullet appears, type your text and press Enter.

If you need many bullet points in one cell, press Alt+Enter (Windows) or Control+Enter (Mac) at the end of each line to move to the next line within that same cell without leaving it. This keeps all your points together in a single cell instead of spreading them across multiple rows.

The character you type does not have to be a traditional bullet. You can use a dash (–), an asterisk (*), or a greater-than sign (>) instead. Pick whichever looks right for your spreadsheet and use it consistently.

Key Takeaways

  • Windows users can create a bullet by holding Alt and typing 0149 on the numeric keypad; Mac users hold Option and press 8.
  • To add multiple bullet points within a single cell, press Alt+Enter (Windows) or Control+Enter (Mac) after each line instead of pressing Enter alone.
  • You can substitute dashes, asterisks, or other characters for traditional bullets if they suit your spreadsheet better.
  • Bullets created this way are plain text characters, not formatting, so they will copy and paste exactly as they appear.
  • If you need bullets in many cells, copying a cell with a bullet and pasting it into other cells saves time over typing the character repeatedly.

Using the character map to find and copy bullets

If the keyboard shortcut does not work on your computer, you can find a bullet character using your system's character map tool. On Windows, search for "Character Map" in the Start menu, find the bullet symbol in the list, click it, then click Copy. Switch back to Excel, click the cell where you want the bullet, and paste it with Ctrl+V.

On Mac, open the Character Viewer by pressing Control+Command+Space, search for "bullet" in the search box, click the bullet symbol, then click the Insert button at the bottom right. The bullet will appear in your active cell.

Once you have pasted a bullet into one cell, you can copy that cell and paste it into others. This is faster than repeating the character map steps for every bullet you need. Just remember to delete the old text and type your new text after the bullet.

Formatting bullets to stand out

After you type a bullet and text into a cell, you can make it bold, change its color, or adjust the font size just like any other text in Excel. Select the cell, then use the formatting buttons in the toolbar to change how it looks. If you want the bullet to be a different color than the text, you will need to select only the bullet character before explore color — click in the cell to edit it, then drag to highlight just the bullet.

Bullets in Excel do not indent automatically the way they do in Word. If you want your bullet points to appear indented from the left edge of the cell, you can add spaces before the bullet character. Type several spaces, then the bullet, then your text. Experiment with the number of spaces until the indentation looks right to you.

Putting multiple bullet points in one cell versus spreading them across rows

Decide whether you want all your bullets in a single cell or each bullet in its own cell. A single cell with multiple bullets works well when you have a short list that belongs together — for example, a list of requirements next to a job title. Multiple cells with one bullet each works better when you want to sort or filter the list later, because Excel treats each row as a separate data point.

If your bullets are in one cell, the cell will be taller than normal to fit all the text. You may need to adjust the row height manually by dragging the row border down. If your bullets are spread across rows, each row stays the same height, but you use more space on your spreadsheet.

Copying bullet points from Word into Excel

If you already have a bulleted list in Word, you can copy it into Excel, but the bullets may not paste the way you expect. Copy the list from Word, then paste it into an Excel cell. The bullets will usually come through as text characters, but they may appear as boxes or strange symbols depending on the font.

If the pasted bullets look wrong, undo the paste with Ctrl+Z, then try pasting as plain text instead. Right-click in the cell and choose "Paste Special," then select "Unformatted Text." This removes the Word formatting and leaves only the characters. You may need to re-add the bullets manually using the methods described above, or you may find the bullets pasted correctly as plain text.

Using a formula to add bullets automatically

If you have a long list of items and want to add a bullet to the beginning of each one without typing the bullet character each time, you can use a formula. In a new column next to your list, type this formula: =CHAR(149)&" "&A1 (replace A1 with the cell containing your first item). Press Enter, then copy this formula down to all the rows with items. A new column will appear with bullets in front of each item.

The CHAR(149) part tells Excel to insert the bullet character. The &" "& part adds a space after the bullet so your text does not touch it. You can then copy the results from the formula column and paste them back into your original column as values if you want to clean up your spreadsheet.

Frequently Asked Questions

Why do I see a box instead of a bullet when I paste from Word?

Word and Excel sometimes use different fonts to display the same character. When you paste, Excel may not recognize the bullet in Word's font. Right-click the cell, choose "Paste Special," select "Unformatted Text," and try again. If boxes still appear, manually type bullets using the Alt+0149 method instead.

Can I make a bullet point in Excel on a Mac without using the keyboard shortcut?

Yes. Open the Character Viewer with Control+Command+Space, search for "bullet," click the bullet symbol, and click Insert. The bullet will appear in your active cell. You can also copy a bullet from another cell and paste it into new cells to save time.

How do I add bullets to multiple cells at once?

Type the bullet and text into one cell, copy that cell, then select all the cells where you want the bullet to appear. Paste with Ctrl+V. The bullet will appear in all selected cells. You can then edit each cell individually to change the text after the bullet.

Will my bullets look the same if someone opens my Excel file on a different computer?

Bullets created with Alt+0149 or Option+8 are standard characters that appear the same on any computer. However, if you change the font of the cell, the bullet may look slightly different because each font renders characters slightly differently. Stick with common fonts like Arial or Calibri if you want bullets to look consistent across computers.

Can I sort or filter a list if the bullets are all in one cell?

No. Excel treats a cell with multiple lines as a single data point, so you cannot sort or filter individual bullet points. If you need to sort or filter, put each bullet point in its own cell in a separate row. If you need bullets to stay together, keep them in one cell but accept that you cannot sort them.