# How to Add Bullet Points in Google Sheets (The Easy Way!)

May 8, 2024

In this article we will show you exactly how to add bullet points in google sheets in three ways. Follow the simple steps below to insert bullets in just a few clicks.

### 1. Double-click the cell where you want to add bullet points

An alternative is to select the cell, then press Enter to enter edit mode.

### 2. Press the Shortcut for Bullet Points (Alt+Numeric Keyboard 7 in Win and Option+Shift+9 on Mac)

Voila! You can now add the value.

### How to Add Multiple Bullet Points in a Single Cell

The solution is simple: press Alt+Enter once you are done adding the item and you want to add another one. Once you have completed the list, just press Enter.

Screencap:

## Insert Bullet Points in Google Sheets using Custom Formatting

### 1. Select Range

For this example, we select column A where we want to convert to a column with bullet points.

### 2. Open Custom number format

You can open Custom number format in two ways:

Method 1: Format > Number > Custom number format

Method 2: Select Custom number format from More formats icon along the main toolbar:

The option Custom number format is at the end of the drop-down box:

### 3. Define Format • @

In the textbox near the top of the box, add the following format:

• @

The character is added before the value. The @ serves as the placeholder for the value, telling Google Sheets that the format allows letters, numbers, and other characters such as punctuation marks.

### 4. Click Apply

You have to put a value in the cell and press Enter for the format to appear:

For this specific example, we want to insert it to an existing list in a column:

We will insert the bullet points character to it in the next column. Here are the steps:

### 1. Select First Cell of Column Where to Add Bullet Points

We want to insert it in column B so we select B1. B1 is also the same row as the first entry in column A.

### 2. Use Formula =CHAR(8226)&” “&A1

=CHAR(8226)&” “&A1

To cell B1.

### 3. Press Enter

The output for B1 looks like this:

### 4. Copy the Formula Down the Column

When you click B1, a small square appears on its lower-right corner. Drag it down so the formula is also added to other rows along the column.

### 5. (Optional) Remove the Original Column

To do so, copy the column containing the bullet points (you can use Ctrl+C keyboard shortcut), then on the same range Paste special as Values only:

You can now delete the original column A. Right-click the column header with A on top, then select Delete column.

## FAQs

### Can I Use Other Symbols as Bullet Points in Google Sheets?

Yes! Here are some alternatives you can use. Set their corresponding values as input to CHAR function in the third method above:

• 8226

● 9679

■ 9632

□ 9633

○ 9675

► 9658

▻ 9659

✓ 10003

✔ 10004

✗ 10007

✘ 10008

Here is a snapshot in Google Sheets, but you can copy and paste them by clicking on our sample sheet:

### Can I…just copy the character itself and paste it in the cell?

Yes, of course! The disadvantage is that it gets lost when you need to copy data from one source to your sheet, which is why we have the three methods in Google Sheets listed here. These methods will help simplify your formatting process.

## Other Google Sheets Formatting Articles

We hope this article has helped you and given you a better understanding of how to add bullet points in Google Sheets. You might also like our articles on how to save a Google Sheet as PDF and how to extract a Google Sheets substring.

To optimize your workflow, we recommend reading our guide on how to send an email from Google Sheets when a sheet is updated.

Get Google Sheets productivity and automation tips delivered straight to your inbox