How to Add Bullets in Google Sheets

As a digital marketer, I know the importance of using bullet points to make content easier to read and understand. Bullets break down complex information into digestible bits, making it easier for readers to comprehend. This principle applies to spreadsheets too, and Google Sheets makes adding bullets to your cells a breeze.

What are Bullets?

Bullets are symbols that help you visually organize and present information. They can be used to create lists of items, steps, or instructions in your Google Sheets. Using these bullets will help your data more easily understood and readable.

How to add bullets in Google Sheets

To add bullets to your Google Sheet cells, simply follow these easy steps:

  1. Launch Google Sheets and create a new sheet. Alternatively, you can open an existing sheet.
  2. Select the cell you want to add bullets to.
  3. Click on the "Format" menu and select "Number". This will open up a drop-down menu with various formatting options.
  4. Scroll down and select "Bullet." With this option, you will see a small bullet in your selected cell.
  5. Keep adding bullets to as many cells as you like.

Formatting Bullets in Google Sheets

If you want to customize the bullet appearance, you can follow these additional steps:

  1. Click on the "Format" menu and select "Conditional formatting".
  2. Scroll down and select "Add new rule." This will open up a pop-up menu where you can input your formatting preferences.
  3. Select the "Custom formula is" option from the drop-down list.
  4. Copy and paste the following custom formula: =char(9679) This formula specifies a bullet in decimal form, which will appear in your cell of choice.
  5. Under "Formatting style", you can add a custom color and font to your bullet.
  6. Click on "Done."


Adding bullets to your Google Sheet cells is a simple yet effective way to make your data more understandable and visually appealing. Use the steps outlined in this guide to add bullets and enhance the readability of your spreadsheets. It's just one of many tips and tricks to make Google Sheets stand out. Give it a try, and you'll notice the difference right away!

By clicking “Accept”, you agree to the storing of cookies on your device to enhance site navigation, analyze site usage, and assist in our marketing efforts. View our Privacy Policy for more information.