.png)
How to Add Bullet Points in Google Sheets (The Easy Way!)
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.
We have created a sample sheet for your convenience. Click here to access the sheet and follow along at home.
Add Bullet Points in Google Sheets Using the Keyboard Shortcut
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.
Screencap
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:
Add Bullet Points in Google Sheets using the CHAR Function
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
Add the formula
=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
-How to Strikethrough in Google Sheets
-How to Remove Gridlines in Google Sheets
-How to Underline in Google Sheets
-How to Hyperlink in Google Sheets
-How to Indent in Google Sheets
-Add Line Break in Google Sheets
