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.
An alternative is to select the cell, then press Enter to enter edit mode.
Voila! You can now add the value.
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:
For this example, we select column A where we want to convert to a column with bullet points.
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:
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.
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:
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.
Add the formula
=CHAR(8226)&” “&A1
To cell B1.
The output for B1 looks like this:
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.
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.
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:
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.
-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
-Color Every Other Row in Google Sheets
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.
