How To Bullet Point In Google Sheets

Google Sheets is an excellent tool for creating spreadsheets, organizing data, and performing calculations. But did you know you can also use it for creating lists with bullet points? In this guide, we will walk you through how to add bullet points in Google Sheets.

Method 1: Using the CHAR Function

The CHAR function in Google Sheets can be used to create bullet points. It allows you to add a specific character, based on its Unicode value.

The Unicode value for a standard bullet point is 8226. Thus, to add a bullet point, you can use the following formula:


After typing this formula in a cell and pressing enter, a bullet point will appear in that cell.

Method 2: Copy and Paste

If you prefer not to remember the Unicode value, you can simply copy a bullet point from another source and paste it into your Google Sheets cell. Just remember, you have to paste it in Edit mode.

Method 3: Using Keyboard Shortcuts

In addition to the aforementioned methods, you can also use keyboard shortcuts to insert a bullet point in Google Sheets.

For Windows users, use the ALT + 7 or ALT + 9 on the numeric keypad of your keyboard to insert a bullet point.

Mac users, on the other hand, can use OPTION + 8 to create a bullet point.

Method 4: Using the Custom Number Formatting Feature

If you want to create a list with bullet points, the Custom Number Formatting feature can be quite handy. Here is how you can do it:

  1. Go to the Format menu.
  2. Select Number.
  3. Then choose More Formats.
  4. Click on Custom number format.
  5. Type in the following: \• @ and click on Apply.

Now, every time you type something in the cell, it will automatically add a bullet point in front of the text. The backslash (\) is used as an escape character to tell Google Sheets to treat the following character as a string, not a command.

We hope this guide helps you understand how to add bullet points in Google Sheets. With these tips, you should be able to create neat and organized lists in your spreadsheets. Happy bullet pointing!