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. You can insert bullet points with a few clicks using Google Docs. But what if you use Google Sheets? Is it possible to add bullet points? Moreover, how do you do it on your smartphone or 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, CHAR function, or copying and pasting the list. Here’s how to use all three options.

Option 1: Use 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. Press “Alt + 7” on Windows or “Option + 7” on Mac.
   
5. You’ll now see a bullet point in the cell.
   

Option 2: Use 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 following text string:
   =CHAR(9679)
   
4. Press “Enter” to execute the formula/text string.
   

Option 3: Use Copy and Paste to Add 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:

• ○ ► ✓

Double-click on the symbol above that you want to use. Then, add it to Google Sheets as follows:

1. Double-click on the symbol below that you want to use.
   •○►✓
2. Open “Google Sheets.”
   
3. Using Windows, you can hold “Ctrl + V” to paste the bullet point in the cell. Mac users should hold “Command + V.”
   

How To Insert a Bulleted List in Google Sheets

What if you need to add more bullet points in Google Sheets? Do you need to write the formula repeatedly, 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 “tiny square” (grab handle) in the bottom right corner of the cell.
   
2. Click on it and drag it down to the cell where you want bullet points to appear.
   

Now, these cells all have bullet points.

How To Create a List Within a Cell in Google Sheets

Perhaps you want to create a list within one cell in Google Sheets, but when you press “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 (see above), copy/paste the bullet point (see above), or use the keyboard shortcut (see above).
   
4. Press “Alt + Enter” (Windows) or “Option + Enter” (Mac) to insert a new line in the same cell. Repeat as needed.
   

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

Aside from PC options (Windows, Mac, and Chromebook), you can add bullets to Google Sheets on Android and iOS. 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 the “Android Google Sheets” or “iOS Google Sheets” app.
   
2. Tap twice on the cell where you want to add a bullet point.
   
3. You’ll now see a keyboard. Type the following text string:
   =CHAR(9679)
   
4. Tap on the “checkmark” symbol.
   

The bullet point now appears in the cell.

---

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

Moreover, it’s also possible to insert bullet points using Google Docs or Slides. You can also personalize them by changing their color or using other characters instead of bullets.

FAQs: Adding Bullet Points to Google Sheets

Can you personalize/customize bullet points in Google Docs?

Yes, Google Docs lets its users personalize bullet points to a style that suits their liking or needs. 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:

1. Click twice on the bullet points.

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

3. Choose the color you like and tap it.

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

1. Click on the bullet point.

2. Right-click on it to open a new menu, then tap on “More bullets.”

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

4. Your new symbol 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:

1. Open Google Slides.

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

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

4. Click on “Bullets and numbering.”

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

6. 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:

1. Click on the bullet point.

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

3. Choose between different options.

How do you add a numbered list in Google Sheets?

Adding numbered lists to Google Sheets is simple. Follow these steps:

1. Open Google Sheets.

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

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

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

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

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

7. Tap “Enter.”

8. The numbers will now be on the left.

What are the keyboard shortcuts to insert bullet points in Google Sheets?

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

1. Open “Google Sheets.”

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

3. Hold “Option” and “7.”

If you’re a Windows user, this is how you can add bullet points in Google Sheets:

1. Launch “Google Sheets.”

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

3. Press “Alt” and “7.”