How To Insert a Bullet List In Google Sheets

Last Updated on October 31, 2023 by Jake Sheridan

In this tutorial, you will learn how to insert a bullet list in Google Sheets.

How To Insert a Bullet List In Google Sheets

Bullet lists are a great way to present data in an easy-to-read format. However, users may find it difficult to create a bullet list within Google Sheets.

In Google Sheets, there is no built-in way to insert a bullet point. However, you can use the CHAR function to insert a bullet point character or any other character for that matter.

You can also create and apply custom number formatting to add a bullet point to the start of each value. This can be helpful if you want to insert a bullet point across an entire range at once.

In this guide, we will show you how to insert a bullet point in Google Sheets using the CHAR function and number formatting.

How To Add a Bullet List In Google Sheets

Here’s how to add a bullet list in Google Sheets.

Step 1

First, we’ll explain how to use the CHAR function to add a bullet list in Google Sheets.

In this method, we’ll start with a range of values in a column and create a duplicate copy of the column with the value appended after a bullet point.

Step 2

The CHAR function allows us to return any character we need and add it to the current cell. The bullet symbol can be retrieved using the function CHAR(8226).

We’ll use the ‘&’ symbol to combine the bullet symbol with the actual value for each bullet point. We’ll also add an empty space “ “ in between to add some distance between the bullet and the list value.

Step 3

Evaluate the function by hitting the Enter key.

Step 4

To generate the rest of the list, simply use the AutoFill action using the cursor.

Step 5

Next, we’ll show you how to use custom number formatting to create a bullet list in Google Sheets.

First, you must select the range you want to convert into a bullet list.

In this example, we want to add a bullet to each value in the range E2:E12.

Step 6

Next, click on the number formatting icon seen below and select the Custom number format option.

Step 7

A new dialog box should appear. Clear out any text in the top textbox and enter the string “• @”. Click on Apply to proceed.

The ‘@’ symbol is used as a placeholder for text. The custom number format syntax indicates that the text will be placed after a bullet point.

Step 8

You should now have a range formatted as a bullet list in Google Sheets.

Step 9

We may also use keyboard shortcuts to insert a bullet point manually for each value in a list.

First, select an empty cell where you want to place the first bullet point.

Step 10

Next, click on the Alt key and hit the ‘7’ in your numeric keypad. A bullet should now appear in the current cell.

Summary

This guide should be everything you need to insert a bullet list in Google Sheets.

You may make a copy of this example spreadsheet to test it out on your own.