In this article:

How to Insert Bulleted or Numbered Lists in Google Sheets

Bullet points, while readily available in Docs and Slides, are unfortunately not a built-in option in Google Sheets and its toolbar. However, there are several ways around this limitation, allowing you to organize your cells like this:

Spreadsheet named "How to Insert Bullet Points..." with a fake To-Do List and two columns with bullet point examples
While bullets and numbering in cells aren’t typical for data processing, we find them helpful for note-taking, nested/multilevel lists, and other organizational uses.


Adding lists within one cell

Referencing the example above, these tutorials cover how you’d create the cell formatting in Row C (as opposed to Row A). Because these methods are not very scalable, we recommend using them for smaller lists (i.e. taking notes, inputting specific details).

Using Mac keyboard shortcuts to create lists

  1. Select desired cell > Press Enter (or double-click).
  2. Press Option + 8 to insert a standard bullet point (or enter item number) > Type your desired text.
  3. Press Control + Enter to insert a line break.
  4. Repeat steps 2-3 for your entire list.

Using PC keyboard shortcuts to create lists

  1. Select desired cell > Press Enter (or double-click).
  2. Press Alt + 7 (on number keypad) to insert a standard bullet point (or enter item number) > Type your desired text.
  3. Press Alt + Enter to insert a line break.
  4. Repeat steps 2-3 for your entire list.

Using Copy + Paste to create custom bulleted lists

  1. Copy your desired bullet style: • ◘ ○ ◙ ‣ ⦾ ⦿ ☐ ✓ ✔ ✗ ✘ ☓ ☑ ☒ 
  2. Select desired cell > Press Enter (or double-click).
  3. Paste bullet > Type your desired text.
  4. Press Alt + Enter to insert a line break.
  5. Repeat steps 3-4 for your entire list.

Adding bullets across multiple cells

Spreadsheet named "How to Insert Bullet Points..." with a fake To-Do List and two columns with bullet point examples


These tutorials will cover how you’d create the cell formatting in Row A (as opposed to Row C). Unlike the previous section, these methods are good for formatting multiple cells in bulk!

Using CHAR to create lists

  1. Select desired cell > Press Enter (or double-click).
  2. Type in the formula =CHAR(8226)&“ ”&A1, A1 being your desired string cell reference, or =CHAR(8226)&“ ABC”, ABC being your desired string.
Spreadsheet named "Pixar Movies" with Column A containing the Movie Names and Column B containing the Movie Names with a bullet point in front

Using Custom Formats to create custom bulleted lists

  1. Select desired column (or row).
  2. Click More Formats button (icon of “123” with downward-facing arrow) in Toolbar > Hover over More Formats > Click Custom number formats. Alternatively, you can search “Custom number formats” in the Help bar.
  3. Copy and paste your desired bullet format ( • ◘ ○ ◙ ‣ ⦾ ⦿ ☐ ✓ ✔ ✗ ✘ ☓ ☑ ☒ ) > Type in “ @” next to it (space included) > Press Apply.
Custom number formats window on Google Sheets with the text "[bullet point] @" entered
"@" references the text currently in each cell!


  1. All your current cells should now have a bullet point in front of it. Further, any cells in your previously selected column (or row) will now automatically have a bullet point once you add text.
Spreadsheet named "Pixar Movies" with Column A containing the Movie Names with a bullet point in front

Automate repetitive tasks with Lido

Save hours on repetitive and tedious work. Lido is a new spreadsheet that connects your spreadsheets, forms, PDFs, and email inbox.

Trigger
Action
Select trigger
When a cell value in Google Sheets changes
Check Google Sheets for today's date
When a new row is added to Google Sheets
On new Google Form submission
Send me a daily reminder
On new Typeform submission
When a cell value in database changes
Check database for today's date
When a new row is added in database
When a new HubSpot customer is created
Select action
ADDCALENDAREVENT
Creates a one- or multiple-day calendar event with optional attendees
ADDHUBSPOT
Adds an object to Hubspot
ADDSLACKCHANNEL
Create a Slack channel, and optionally add a topic or members
CALLURL
Makes any HTTP request
CREATEGOOGLEDOC
Replaces [@column_name] values in a Google Doc with the corresponding table row's values
CREATEPDF
Replaces [@column_name] values in a Google Doc with the corresponding table row's values, then export it as a PDF
FETCH
Makes any HTTP request and returns the response
INSERTROWS
Inserts given array below defined values in given worksheet
SENDGMAIL
Sends an email using your Google account
SENDOUTLOOK
Sends an email using your Microsoft Outlook account
SENDSLACK
Sends a Slack message
SENDSMS
Sends an SMS message using your Twilio account
UPDATECELL
Updates cells with given values
UPDATEHUBSPOT
Updates a property of a Hubspot object
Trigger is required
Action is required
Get started