How to create bullet points in Google Sheets

Google Sheets doesn't have bullet points to create the type of list you want like when creating a list in Google Docs.

 However, if you want to insert bullet points, Google Sheets is also very simple, such as using keyboard shortcuts. Using the function in Google Sheets to create bullet points is also an easy-to-use function that is not complicated. The following article will show you how to create bullet points in Google Sheets.

Insert bullet points in Google Sheets with keyboard shortcuts

In the cell you want to insert a bullet point, hold down the Alt key and then press the number 7 . Soon you will see a bullet point.

How to create bullet points in Google Sheets Picture 1How to create bullet points in Google Sheets Picture 1

In case you want to create a list in a Sheets cell , we will use the ALT + Enter key combination to enter a line break in the same cell.

How to create bullet points in Google Sheets Picture 2How to create bullet points in Google Sheets Picture 2

 

Then we insert bullet points for each content in 1 cell.

How to create bullet points in Google Sheets Picture 3How to create bullet points in Google Sheets Picture 3

Insert bullet points with the CHAR function Google Sheets

In the cell where we want to insert a bullet point, we enter the function formula =CHAR(8226) .

How to create bullet points in Google Sheets Picture 4How to create bullet points in Google Sheets Picture 4

The result also shows a dot icon as shown below.

How to create bullet points in Google Sheets Picture 5How to create bullet points in Google Sheets Picture 5

Next we will combine the CHAR function with the content cell to form the list we need. You enter the function formula =CHAR(8226)&" "&D46 where D46 is the reference cell with the content you want to create a bullet point.

How to create bullet points in Google Sheets Picture 6How to create bullet points in Google Sheets Picture 6

 

When you press Enter, the content will be added a bullet point. Now you just need to drag the first cell down to the other to add a bullet point in Google Sheets.

However, with this method, you are forced to create a new column to create bulleted content.

How to create bullet points in Google Sheets Picture 7How to create bullet points in Google Sheets Picture 7

Google Sheets bulleted custom formatting

Step 1:

Select the cells where you want to add a bullet point. Next, click on Format and then click Number below. Next click on Custom Number Format .

How to create bullet points in Google Sheets Picture 8How to create bullet points in Google Sheets Picture 8

Step 2:

Display the interface so that we can adjust the format to our liking. You find the style .@ and then press Apply to create a bullet point.

How to create bullet points in Google Sheets Picture 9How to create bullet points in Google Sheets Picture 9

 

As a result, we have a list as shown below.

How to create bullet points in Google Sheets Picture 10How to create bullet points in Google Sheets Picture 10

If you don't like the . then you can enter another mark to use. The @ symbol represents what you type. For example, use the - sign before the content in Excel you will enter - @ and then press Apply.

How to create bullet points in Google Sheets Picture 11How to create bullet points in Google Sheets Picture 11

As a result we will see a list with the - icon in front of the content.

How to create bullet points in Google Sheets Picture 12How to create bullet points in Google Sheets Picture 12

4 ★ | 1 Vote