✦Template Printable Ideas Insights

Can You Do Bullet Points in Google Sheets?

By

Have you ever found yourself wishing you could create bullet points in Google Sheets, only to be met with frustration by the lack of this seemingly simple feature? You're not alone. Google Sheets, for all its power and simplicity, doesn't natively support bullet points. However, don't lose hope just yet. There are indeed ways to achieve this, and in this guide, we'll explore them in detail.

Before we dive in, let's clarify what we mean by "bullet points". In this context, we're referring to the ability to list items horizontally or vertically with symbols (like circles, squares, or numbers) next to them. This is often used to create outlines, enhance readability, or simply break down information into manageable chunks.

Using Autofill for Bullet Points

One of the quickest ways to create bullet points in Google Sheets is by utilizing the Autofill feature. This method works best when you want to create a list of items with a common symbol (like a circle or a square).

MARKERS
MARKERS
> Bullet Points
> Bullet Points
a hand is pointing at a notebook with the words rate my pay on it
a hand is pointing at a notebook with the words rate my pay on it

Here's how it works:

  1. Write the first item of your list in a cell. To have it act as the symbol for the rest of the list, leave the cell immediately to the left or right of the item empty.
  2. Hover your mouse cursor over the small square in the bottom-right corner of the cell containing the item. When the cursor changes to a plus sign, click and drag it over the neighboring empty cells where you want your list to extend.
  3. Release the mouse button. Google Sheets will automatically fill in the remaining cells with the appropriate symbols and the rest of your list.

It's important to note that this method doesn't create true bullet points; it's more of a hack. The symbols aren't bullet points in the traditional sense, and they won't behave like real bullet points in all situations.

an excel spreadsheet with the text'none'highlighted on it, along with other numbers and symbols
an excel spreadsheet with the text'none'highlighted on it, along with other numbers and symbols
How to Add Bullet Points in Google Sheets
How to Add Bullet Points in Google Sheets
a page with different types of lines and numbers on it, all lined up in the same row
a page with different types of lines and numbers on it, all lined up in the same row

Creating a Custom List

If the Autofill method isn't robust enough for your needs, you might want to create a custom list. This involves using the INDIRECT function in conjunction with a separate sheet to create a true bullet-pointed list. Here's how you can do it:

1. Create a new sheet and name it "Bullet Points". In the first column, starting from cell A1, create a list of symbols you want to use as bullet points (e.g., "➢", "•", "①", etc.).

2. In the cell where you want your bullet-pointed list to start in your original sheet, enter the following formula: `=ARRAYFORMULA(INDIRECT(b1&"1:"&b2"))`. Replace `b1` with the cell containing the first number in your range (e.g., "A1") and `b2` with the cell containing the last number in your range (e.g., "A10").

a notebook with some writing on it and a pen next to the page that has been written
a notebook with some writing on it and a pen next to the page that has been written
Bullet points
Bullet points
How to Doodle Cute Borders in Your Bullet Journal
How to Doodle Cute Borders in Your Bullet Journal
Easy notes and titles
Easy notes and titles
a year in pixels 2013 - 2013 is shown on a page from the planner book
a year in pixels 2013 - 2013 is shown on a page from the planner book
Aesthetic Bullet Points, Bullet Points For Notes, Aesthetic Arrows For Notes, Bullet Points In Notes, Cute Arrows For Notes, Notes With Bullet Points, Arrows For Notes, Arrow Journal Ideas, Cute Dividers For Notes
Aesthetic Bullet Points, Bullet Points For Notes, Aesthetic Arrows For Notes, Bullet Points In Notes, Cute Arrows For Notes, Notes With Bullet Points, Arrows For Notes, Arrow Journal Ideas, Cute Dividers For Notes

3. After entering the formula, press Enter. Your true bullet-pointed list should now appear.

While this method creates a true bullet-pointed list, it does require maintaining a separate sheet for the symbols and using an array formula, which might not be ideal for everyone.

Using Add-ons for Bullet Points

If all else fails, there are always add-ons. Google Sheets has a vast library of add-ons created by third-party developers. Some add-ons, like Table Builder or Acadami, allow you to create bullet points with ease. Here's how you can use the Table Builder add-on to create bullet points:

Notes by me ☺️
Notes by me ☺️
some type of lettering that is in different colors and styles on a sheet of paper
some type of lettering that is in different colors and styles on a sheet of paper
50+ FREE Printable Bullet Journal Pages
50+ FREE Printable Bullet Journal Pages

1. Open your Google Sheets document and click on "Extensions" in the menu, then "Add-ons".

2. In the "Add-ons" sidebar that appears, search for "Table Builder".

3. Click on the "+ FREE" button next to Table Builder to install it.

4. Once installed, click on "Table Builder" in the sidebar, then "Create a table".

5. In the new window that opens, select "Use range" and choose the cells you want to turn into a table. Click "OK".

6. In the next window, under the "Table style" section, click on "+" next to "Start each header with". Here, you can choose the symbol you want to use as a bullet point. Click "OK" when you're done.

7. Your bullet-pointed list should now appear in your Google Sheets document.

While Table Builder does create real bullet points, it's important to note that it also imposes a stylesheet on your table, which might not be desirable in all situations. Additionally, this method third party add-ons might not suit everyone due to the potential risks and additional costs involved.

Emoji Bullets

Another workaround for creating bullet points in Google Sheets is by using emojis. While not traditional bullet points, emojis can serve the same visual purpose and can be easier to implement than the other methods discussed.

To use emojis as bullet points, follow these steps:

1. Write your list items in a column.

2. In the cell immediately to the left of the first list item, enter the emoji you want to use as a bullet point (e.g., "•", "🚩", etc.).

3. Select the cell containing the emoji and drag it down to copy the emoji for each list item.

This method isn't perfect, as emojis don't function as true bullet points, and they might not be suitable for all situations. However, it's a simple and quick solution that works in a pinch.

Bullet points in Google Sheets might not be a native feature, but with a bit of creativity and the right tools, you can create workarounds that work just as well. Whether you opt for Autofill, custom lists, add-ons, or emoji bullets, there's a solution out there that's sure to meet your needs. Happy bullet-pointing!