1
Select the list
Highlight the cells that should get bullets.
How to add bullet points in Google Sheets
Put a bullet in front of every item with a custom number format, without retyping it.
Professional Hacks
2
Click Format
Open the Format menu.
3
Click Number
Hover over Number to open its submenu.
4
Click Custom number format
Choose Custom number format at the bottom of the list.
5
Click the format box
Click the box at the top of the window.
6
Type "• "@
Type "• "@ - a bullet and a space in quote marks, then @. Type the bullet with Alt + 7 on Windows or Option + 8 on Mac.
7
Click Apply
Click Apply to format the selected cells.
8
Bullets added
Every selected cell now starts with a bullet, and new text you type there gets one too.
Make this walkthrough your own
Duplicate this template, swap in your own screens, and share it with your team. Free to start — no credit card.