How to Add Bullet Points in Google Sheets

When you’re making lists, bullet points can come in handy. They neatly separate everything and enable you to organize information. When you use Google Docs, you can insert bullet points with a few clicks. But what if you use Google Sheets? Is it possible to add bullet points? Moreover, how do you do it on your smartphone or on a computer?

If you’ve been looking for answers to those questions and more, you’ve come to the right place. In the next few sections, you’ll read about adding bullet points in Google Sheets and much more.

How to Add Bullet Points in Google Sheets on Windows, Mac, and Chromebook

There are three methods to add bullet points in Google Sheets on Windows, Mac, and Chromebook: using the keyword shortcut, using the CHAR function, or copying and pasting the list. Let’s explore these options in-depth:

Using a Keyboard Shortcut to Add Bullet Points on Windows, Mac, and Chromebook

Using a keyboard shortcut to add bullet points on Windows, Mac, and Chromebook is probably the simplest method. Here’s what you need to do:

  1. Open Google Sheets on your computer.

  2. Select the cell where you want to add bullet points.

  3. Double-click the cell or hit F2.

  4. Hold the “Alt” key if you are a Windows user and then hit “7” or “Option” if you’re a Mac user and then “7.”

  5. There will be a bullet point in the cell.

Note: With this keyboard shortcut, bullet points are automatically added.

Using a CHAR Function to Add Bullet Points on Windows, Mac, and Chromebook

Another way to add bullet points in Google Sheets if you’re using a computer is to apply a CHAR function. This is the formula you should remember:

“=CHAR(9679)”

 So, to add bullet points, this is what you should do:

  1. Open Google Sheets.

  2. Tap on the cell where you want to add bullet points.
  3. Copy and paste the formula above or type it.

  4. Hit “Enter.”

Copy and Paste Bullet Points

It’s also possible to copy and paste the bullet list from the web or other apps. Here are some of the bullet symbols you can use:

• ○ ► ✓

To copy one of these, double-click on the one you want to use. Then, add it to Google Sheets as follows:

  1. Open Google Sheets.

  2. If you use Windows, you can hold “Ctrl” and “V” to paste the bullet point in the cell. Mac users should hold “Cmd” and “V.”

How Do You Insert a Bulleted List on Google Sheets?

What if you need to add more bullet points in Google Sheets? Do you need to write the formula every time or can you use a keyboard shortcut? Luckily, there is a solution that is easier than both of those methods. All you need to do is drag the formula down. Here’s how you can do it:

  1. Place the cursor on the square in the bottom right corner of the cell.

  2. Click on it and drag it down to the cell where you want to have bullet points.

There you go. Now these cells all have bullet points.

How Do You Create a List Within a Cell in Google Sheets?

Perhaps you want to create a list within a cell in Google Sheets. But when you hit “Enter,” your cursor is sent to the new cell. How do you add bullet points to the same cell? Follow these steps:

  1. Open Google Sheets.
  2. Tap on the cell where you want to add bullet points.

  3. Add the bullet point using the CHAR function, copy the bullet point, or use the keyboard shortcut.

  4. Press the “Alt” key (Windows users) or “Option” (Mac users) and “Enter.” Doing so will insert a new line.

  5. Add another bullet point using the preferred method.

How to Add Bullet Points in Google Sheets on iOS and Android

If you use Google Sheets on your phone, you’re probably wondering if it’s possible to add bullet points while using the device, or do you need to log on to your computer to insert bullet points. Don’t worry, it’s easy to add bullet points in Google Sheets on iOS and Android phones using the CHAR function. This is how you can do it:

  1. Open Google Sheets on your phone.

  2. Tap twice on the cell where you want to add a bullet point.

  3. You’ll now see a keyboard. Type “CHAR(9679).”

  4. Tap on the checkmark symbol.

The bullet point will now show in the cell.

Additional FAQs

As you can see, adding bullet points in Google Sheets isn’t as difficult as it seems. But you need to be familiar with different methods. In the next section, we’ll explore some of the questions Google Sheets users ask most.

How Do You Add Bullet Points in Google Docs?

Adding and managing bullet points in Google Docs is relatively simple.

Here’s how you can do it:

• Open Google Docs.

• Head over to “Formats.”

• Click on “Bullets and numbering.”

• Select “Bulleted list.”

• Choose the type of list you like and click on it.

Note: It’s also possible to write the list before adding bullet points. But if you realize you want to add bullet points, select the whole list, and follow the steps above.

Personalizing Bullet Points in Google Docs

Google Docs lets its users personalize bullet points. For example, instead of the regular black color of the bullet points, you can choose various other color options. This is how to do it:

• Click twice on the bullet points.

• Tap “A” in the menu bar. This brings up the “Text color” menu.

• Choose the color you like and tap it.

Moreover, you can choose different characters to serve bullet points. To do that, follow these steps:

• Click on the bullet point.

• Right-click on it to open a new menu Tap on “More bullets.”

• This will open a selection of characters. Choose the one you like.

• The new symbol you chose will immediately replace the old bullet point.

How Do You Add Bullet Points on Google Slides?

If you use Google Slides to make a presentation, there might come a time when you need to add bullet points. So how do you do it? Just follow the procedure below:

• Open Google Slides.

• Choose the presentation where you want to add bullet points.

• Head over to “Formats” in the menu bar.

• Click on “Bullets and numbering.”

• Choose between “Numbered list” and “Bulleted list.”

• Once you decide between these two options, select the type of bullets you like the most.

Just as it’s possible to personalize bullet points in Google Docs, you can do the same in Google Slides. This is how to do it:

• Click on the bullet point.

• Right-click on it to open the menu and select “More bullets.”

• Choose between different options.

How to Add a Numbered List in Google Sheets

Since we’ve covered how you can add a bulleted list in Google Sheets, you are probably wondering how to add a numbered list. To do so, make sure to follow these steps:

• Open Google Sheets.

• Click twice on the cell where you want to write the first number.

• Write the following number in the cell below and select those two cells.

• Hover over the square in the bottom right corner of the bottom cell. The cursor will change into a cross.

• Drag down until you select all the cells to which you want to add numbers.

• When you finish, write the text in the first cell.

• Tap “Enter.”

• The numbers will now be on the left.

Are There Keyboard Shortcuts to Insert Bullet Points in Google Sheets?

Keyboard shortcuts can save a lot of time when you’re in a hurry. So although it’s possible to use a function to add bullet points in Google Sheets, you can also use shortcuts.

If you’re a Mac user and want to add bullet points in Google Sheets, this is what you need to do:

• Open Google Sheets.

• Tap twice on the cell where you want to add bullet points.

• Hold “Option” and “7.”

On the other hand, if you’re a Windows user, this is how you can add bullet points in Google Sheets:

• Launch Google Sheets.

• Click twice on the cell where you need to add bullet points.

• Press “Alt” and “7.”

Make Use of Bullet Points

Adding bullet points in Google Sheets can be simple, provided that you follow the methods we listed in the sections above. Whether you choose to add them using the CHAR function, the keyboard shortcuts, or you paste them from another program, we’re sure you won’t have any problems in the future.

Moreover, it’s also possible to insert bullet points when you use Google Docs or Slides. You can also personalize them by changing their color or even use other characters in place of the bullets.

Why do you usually use bullet points? Do you prefer numbered or bulleted lists? Or do you like to use other characters? Let us know in the comments section below.

Leave a Reply

Your email address will not be published. Required fields are marked *

Disclaimer: Some pages on this site may include an affiliate link. This does not effect our editorial in any way.