# 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

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

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.

### 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.

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.

# 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
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
Creates a one- or multiple-day calendar event with optional attendees
Create a Slack channel, and optionally add a topic or members
CALLURL
Makes any HTTP request
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