Google Sheets doesn't have a built-in bullet point feature like Docs does

If you're used to making bullet lists in Google Docs, you'll notice Google Sheets works differently. Sheets is built for numbers and data in cells, not formatted text. There's no bullet button in the toolbar, and you can't select text within a cell and explore bullets the way you would in a word processor.

But you can still create bullet points in Sheets using a few straightforward methods. The simplest is typing them manually using your keyboard. The most flexible is using a special character code that Sheets recognizes. Both take seconds once you know the steps.

Key Takeaways

  • The fastest way to add a bullet is to type it directly: hold Alt and press 0149 on a Windows keyboard, or use the Insert menu on any device.
  • Each bullet point goes in its own cell, not multiple bullets in one cell, because Sheets treats each cell as a single data unit.
  • You can format bullet cells like any other cell — change the font, color, or alignment without affecting the bullet itself.
  • If you need multiple bullet points in one cell, you can paste them from Google Docs, but they won't display as formatted bullets in Sheets.

Type a bullet using your keyboard

The quickest method depends on whether you're on Windows or Mac. On Windows, click the cell where you want the bullet, then hold down Alt and type 0149 on the numeric keypad (not the number row). Release Alt and a bullet appears. On Mac, hold Option and press 8, then release both keys.

After the bullet appears, type your text. If you want another bullet point, press Enter to move to the next cell and repeat the process. This keeps each bullet in its own row, which is how Sheets is designed to work.

Use the Insert menu to add a bullet

If the keyboard shortcut doesn't work on your device, use the Insert menu instead. Click the cell where you want the bullet. Go to Insert in the menu bar, then select Special characters. A window opens with a search box at the top.

Type "bullet" in the search box. A filled circle bullet (•) appears in the results. Click it, and it inserts into your cell. You can then type your text after it. This method works the same way on Windows, Mac, and Chromebook.

Put each bullet point in its own cell

Google Sheets is organized by cells, not paragraphs. Each cell is meant to hold one piece of data. If you put multiple bullet points in a single cell, they'll stack vertically but won't look like a formatted list — they'll just be text on separate lines within that one cell.

The cleaner approach is to put each bullet in its own cell in a single column. This way you can sort them, filter them, or move them around if you need to. It also makes the spreadsheet easier to read and work with if you're sharing it with others.

Format bullet cells to match your spreadsheet

Once you've added bullets, you can format them like any other cell. Select the cells with bullets, then use the toolbar to change the font, font size, or color. You can also adjust the alignment — left, center, or right — without affecting the bullet itself.

If you want all your bullets to stand out, try adding a background color to those cells or making the text bold. These formatting changes work exactly as they do for regular text in Sheets, so you're not learning anything new.

Paste bullets from Google Docs if you already have them

If you've already created a bulleted list in Google Docs, you can copy it and paste it into Sheets. Open your Docs file, select the bulleted list, and copy it (Ctrl+C or Cmd+C). Then click a cell in Sheets and paste (Ctrl+V or Cmd+V).

Sheets will paste the bullets as text, but they won't keep the formatted bullet styling from Docs. Instead, you'll see the bullet character followed by the text in each cell. You may need to adjust spacing or alignment after pasting, but the content is there and ready to use.

Frequently Asked Questions

Can I put multiple bullet points in one cell?

Yes, but they won't display as a formatted list. If you press Enter within a cell (Ctrl+Enter on Windows, Cmd+Enter on Mac), you create a line break and can add another bullet. However, the cell will show all the text stacked together, which looks cramped. It's cleaner to use one bullet per cell in a column.

Why doesn't the Alt+0149 shortcut work on my keyboard?

The numeric keypad shortcut only works on Windows keyboards with a separate numeric keypad on the right side. If you're on a laptop without one, use the Insert menu instead. On Mac, the Option+8 shortcut works on all keyboards.

Can I use a different bullet style, like a dash or arrow?

Yes. Use the Insert menu and search for "dash" or "arrow" to find other characters. Common alternatives are the en dash (–), em dash (—), or right arrow (→). Type the character you want, then your text. Sheets treats all of these the same way as a regular bullet.

Will my bullets stay if I sort or filter the spreadsheet?

Yes. The bullet character is part of the cell's text, so it moves with the data when you sort or filter. If you sort by the column with bullets, the bullets stay attached to their text.

Can I make a bullet list that looks like the one in Google Docs?

Not exactly. Sheets doesn't have a formatting option that creates the indented, formatted bullet lists you see in Docs. You can create the visual appearance by typing bullets manually and adjusting spacing and indentation, but Sheets treats it as regular text in cells, not as a formatted list object.