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:
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
Select desired cell > Press Enter (or double-click).
Press Option + 8 to insert a standard bullet point (or enter item number) > Type your desired text.
Press Control + Enter to insert a line break.
Repeat steps 2-3 for your entire list.
Using PC keyboard shortcuts to create lists
Select desired cell > Press Enter (or double-click).
Press Alt + 7 (on number keypad) to insert a standard bullet point (or enter item number) > Type your desired text.
Press Alt + Enter to insert a line break.
Repeat steps 2-3 for your entire list.
Using Copy + Paste to create custom bulleted lists
Select desired cell > Press Enter (or double-click).
Paste bullet > Type your desired text.
Press Alt + Enter to insert a line break.
Repeat steps 3-4 for your entire list.
Adding bullets across multiple cells
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
Select desired cell > Press Enter (or double-click).
Type in the formula =CHAR(8226)&“ ”&A1, A1 being your desired string cell reference, or =CHAR(8226)&“ ABC”, ABC being your desired string.
Using Custom Formats to create custom bulleted lists
Select desired column (or row).
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.
Copy and paste your desired bullet format ( • ◘ ○ ◙ ‣ ⦾ ⦿ ☐ ✓ ✔ ✗ ✘ ☓ ☑ ☒ ) > Type in “ @” next to it (space included) > Press Apply.
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.
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