How to create bullet points in Google Sheets

 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.

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.

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

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) .

The result also shows a dot icon as shown below.

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.

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.

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 .

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.

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

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.

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

Samuel Daniel

Update 09 August 2023