Are you tired of boring, plain lists in Google Sheets? Spice up your spreadsheets with bullets! In this article, we’ll show you three different ways to add bullets in Google Sheets. Follow the simple steps below and impress your colleagues with professional-looking lists.
Add Bullets in Google Sheets using Keyboard Shortcuts
Adding bullets to your cells can be done in just a few clicks using keyboard shortcuts. Here’s how:
-
Double-click on the cell where you want to add bullets. Alternatively, select the cell and press Enter to enter edit mode.
-
Use the keyboard shortcut for bullets. On Windows, it’s Alt+Numeric Keyboard 7, and on Mac, it’s Option+Shift+9.
That’s it! You can now add your desired value after the bullet.
How to Add Multiple Bullets in One Cell
Do you want to create a list with multiple bullets in a single cell? Follow these steps:
- Type your first entry and press Alt+Enter when you want to add a new bullet. Press Enter when you’re done with the list.
Insert Bullets in Google Sheets using Custom Formatting
Custom formatting allows you to convert a range of cells into a bullet list. Here’s how you can do it:
-
Select the range of cells you want to convert into bullets. For example, let’s select column A.
-
Open “Custom Format.” You can do this in two ways:
- Method 1: Go to Format > Number > Custom Format.
- Method 2: Select “Custom Format” from the “More Formats” icon on the main toolbar. You’ll find it at the bottom of the dropdown list.
-
Set the format to • @. In the text box at the top of the dialog box, enter the following format:
- • @
The bullet character will be added before the cell value. The @ serves as a placeholder for the value, allowing Google Sheets to include letters, numbers, and other characters such as punctuation.
- Click on “Apply.” You’ll need to enter a value in the cell and press Enter for the formatting to appear.
Add Bullets in Google Sheets using CHAR Function
If you want to add bullets to an existing list in a column, follow these steps:
-
Select the first cell in the column where you want to add bullets. Let’s say we want to add bullets to column B, so we select B1. B1 is on the same row as the first entry in column A.
-
Use the formula =CHAR(8226)&” “&A1. Enter the formula =CHAR(8226)&” “&A1 in cell B1.
-
Press Enter. The output in B1 will look like this.
-
Copy the formula throughout the column. When you click on B1, a small square will appear in the bottom-right corner. Drag it down to apply the formula to the rest of the column.
-
(Optional) Remove the original column. To do this, copy the column containing the bullets (you can use the Ctrl+C keyboard shortcut) and then paste it as “Values Only” in the same range. Now, you can safely delete the original column. Right-click on the column A header and select “Delete column”.
FAQ
Can I use other symbols as bullets in Google Sheets?
Absolutely! Here are some alternatives you can use. Set their corresponding values as input to the CHAR function in the third method above:
- • 8226
- ● 9679
- ■ 9632
- □ 9633
- ○ 9675
- ► 9658
- ▻ 9659
- ✓ 10003
- ✔ 10004
- ✗ 10007
- ✘ 10008
Can I simply copy and paste the bullet character itself into the cell?
Certainly! However, keep in mind that it might get lost when you need to copy data from a source to your sheet. That’s why we have listed these three methods in Google Sheets. These methods will help simplify your formatting process.
We hope this article has helped you gain a better understanding of how to add bullets in Google Sheets. You may also be interested in our articles on how to save a Google Sheet as a PDF and how to extract a substring from a Google Sheet.
To optimize your workflow, we recommend reading our guide on how to send an email from Google Sheets when a sheet is updated and trying out our software to help you track legal deadlines.
For more Google Sheets techniques and other marketing tips, visit Crawlan.com.
