All articles

How to Add Bullet Points in Google Sheets

Last Updated: Thu Oct 24 2024

In 4 simple methods, this guide will show you how to add bullet points in Google Sheets.

Enhancing the clarity and organization of your data is easy with these techniques.

So let’s dive in and add bullet points in Google Sheets!

Methods:

• Using the Keyboard Shortcut
• Add Multiple Bullet Points in a Single Google Sheet Cell
• Using Custom Number Formatting
• Using the CHAR Function

Method 1: Using the Keyboard Shortcut

Double-click on the cell where you want to add a bullet point. Alternatively, you can select the cell and press Enter.

For Windows users, press Alt + 7 (using the numeric keypad). For Mac users, press Option + 8.

Your bullet point will appear in the selected cell.

Method 2: Add Multiple Bullet Points in a Single Google Sheet Cell

Follow the steps in Method 1 to add the first bullet point.

Press Alt + Enter to create a new line within the same cell.

And then do the steps again shown in method 1:

For Windows users, press Alt + 7 (using the numeric keypad). For Mac users, press Option + 8.

Continue to press Alt + Enter to create a new line.

Method 3: Using Custom Number Formatting

Highlight the range of cells where you want to add bullet points.

Go to Format in the top menu. Select Number and click on Custom number format.

Alternatively:

Click on the More formats icon on the toolbar. Select Custom number format.

In the Custom Number Format dialog box, type • @ in the text field.

Click Apply.

The selected cells will now display bullet points before their values.

Method 4: Using the CHAR Function

Click on the cell where you want to insert a bullet point.

Type =CHAR(8226)&" "&A1 into the cell, replace A1 with the reference to the cell where you want to add a bullet point to.

Press Enter to apply the formula. A bullet point will appear before the text in the referenced cell.

Click the small square at the bottom-right corner of the cell.

Drag it down to copy the formula to other cells in the column.

By using keyboard shortcuts, custom number formatting, or the CHAR function, you can easily add bullet points in Google Sheets.

These methods help make your data more organized and visually appealing.

Try each method to see which one works best for your needs!