Skip to content

How to Use Custom Bullet Points in Google Sheets? 

Looking to Use Custom Bullet Points on Google Sheets. Here is the Simple Guide to Add Custom Bullets in Google Sheets App or Website.
How to Add Custom Bullets in Google Sheets

Google Sheets is a free platform used for creating and managing spreadsheets. Users can produce and alter spreadsheets right in their web browser with Google Sheets without any additional software. Multiple people can work simultaneously and see each other’s changes in real-time. This Google offering has become quite popular more than ten years after its launch. This is mainly because of its handy features. Easy collaboration, integration with other platforms, and a simple interface are some of its best features.

In this guide, we’ll be talking about adding custom bullets in Google Sheets. Sometimes the nature of the information requires it to be organized with the help of bullet points. There is not an official Google Sheets feature that allows users to add bullets, but by using a few tricks, users can add bullets.

Adding bullets in Google Sheets

In Google Sheets, there are a few methods for inserting bullet points; however, there is no straightforward way to do so. There are different methods, from using a keyboard shortcut to using the CHAR function. We have listed all possible methods of adding bullets in Google Sheets.

Method 1: Keyboard shortcut

The simplest approach for adding bullet points in Google Sheets is to use a keyboard shortcut. This works best for when you want to add one or two bullet points quickly.

Step 1: Go to Google Sheets.

Open Google Sheets

Step 2: Locate and select the cell where you want the bullet point to appear. Then press the F2 key or double-click the cell.

Select Cell

Step 3: Hold down the Alt key and then press the 7 key on the keyboard. The bullet point will appear beside the text; however, you can shift the text around.

Bullets Added Sheets

The bullet point will appear in the selected cell in the sheet.

Method 2: Copy-pasting Bullet points into a Cell in Google Sheets

Copy-pasting bullet points into a cell in Google Sheets is also possible. This is yet another easy method of adding bullets. A variety of bullets can be copied and pasted into Google Sheets cells.

Step 1: Copy the bullet you want to insert in Google Sheets from any source like Google Docs or Microsoft Word. You can even copy the bullet points from a website online. There are many websites that have a collection of unique bullet points. Here’s a screenshot from piliapp.com, which houses many kinds of bullet points.

Copy Custom Bullet Online

Step 2: Go to Google Sheets.

Select Cell Google Sheets

Step 3: Paste the bullet in the cell of your choice.

Add Custom Bullets Google Sheets

The bullet will be added to the cell.

Method 3: Using the CHAR function

The CHAR function is another wonderful method for adding bullet points to Google Sheets. This can be done by using the special Unicode number of bullets in the CHAR formula.

Step 1: Go to Google Sheets.

Step 2: Click on the cell beside which you want to insert the bullet, type the given function combined with the cell address. The bullet will be displayed in the new cell; however, you can delete the original cell later. You can apply the formula to multiple cells to get the desired result.

=CHAR(8226)

Select Cell B

CHAR Google Sheets Bullets

Step 3: Hit the Enter Key, and the bullet will be displayed in the adjacent cell. Remember that you can delete cells to avoid duplicate cells.

Use Custom Bullet Points Google Sheets

Method 4: Using a Custom Format

Using the custom format method to add bullets is a slightly lengthy but simple process. Additionally, this method comes in handy when a user wants to add numerous bullet points.

Step 1: Go to Google Sheets.

Step 2: Locate and select the cells in which you want to add the bullet points.

Fill Content Google Sheets

Step 3: Click on ‘Format‘ in the menu located at the top. Click on ‘Number’ and then click on ‘More Formats‘. Choose ‘Custom Number Format’ from the menu.

Custom Format

Step 4: The ‘Custom Number Format’ menu will be displayed on the screen. In the dialog box, enter/paste ‘•@‘ and hit ‘Apply’.

Custom Number Formats

The bullet points will appear once you click on ‘Apply’.

Bullets Added

Conclusion

That’s it, folks! This guide described the process of adding custom fonts in Google Sheets. While Google Sheets is a fantastic platform, adding custom bullets can make it even better. Try it yourself by following the given steps and let us know if it worked!

Leave a Reply

Your email address will not be published.