How to Add Bullets in Google Sheets

While there is a simple click option to insert bullets into Google Docs, there is no easy way to insert bullets into Google Sheets. The reason for the need for bullet points in Google Sheets may be less. But if you’re one of those people who want bullets, here are some ways in which you can do it. This article will look at how to insert bullets into Google Sheets. We will look at different methods for this as well as keyboard shortcuts. We aim to discuss different ways to insert bullets into Google Sheets. By the end of this article, you will be familiar with more than one technique for converting a spreadsheet-based list into a bulleted list.

 We will discuss several ways to insert bullets into Google Sheets. Some methods are more straightforward than others. We will start with the custom format method and the CHAR formula method. We will also look at keyboard shortcuts and copy-and-paste techniques.

 So, we have plenty of lands to cover. Let’s go straight to our first method.

The keyboard shortcut for inserting bullet points into Google Sheets

 Here are the steps to insert a bullet point into a cell in Google Sheets:

  • Select the cell in which you would like to insert the bulleted end.
  • Go into edit mode (pressing the F2 key or double-clicking on the cell).
  • Press the number 7 on the numeric keyboard while holding down the ALT key.
How to Add Bullets in Google Sheets

It will instantly add a bullet to the cell in the Google Sheets.

If you want to insert multiple bullets in different lines in the same cell, press Alt + Enter to move to a new line in the same cell. Now hold the ALT key again and press the number 7 on the keypad.

How to add bullet points to Google Sheets using the CHAR function

This method of inserting bullets into Google Sheets involves using the CHAR formula. It is a solid and dynamic method that can show changes in the original list. In the stages that follow, we’ll see this in action.

Now before you learn how to use the CHAR function, it is recommended that you read its official documentation and get acquainted with it.

Here are the steps:

  • Enter the following function in the cell to insert the bullet. = CHAR (8226)
  • Press Enter.

This will instantly insert a bullet into the cell. You can also create formulas to get a bulleted list automatically. For example, suppose you have a list of items as shown below:

Using this list, create a bulleted list:

  • Enter the following formula in cell B1: = CHAR (8226) & “” & A1
  • Copy-paste for all cells.

The CHAR part of the formula returns the bullet and then adds the item’s name in front of it.

How to insert bullets into Google Sheets (using keyboard shortcuts)

We’ll show you a keyboard shortcut to insert a bullet mark into a cell. Getting used to this keyboard shortcut can be very handy. There are three simple steps to using this shortcut.

  • Choose the cell where you want the bullet to go.
  • Click the F2 button on your keyboard to activate the edit mode.
  • Now, hold the ALT key and press seven on your numeric keyboard.
  • If you want to insert more than one bullet symbol into a cell, hold down the ALT key and press Enter. You will move to a new line in the same cell.
  • Repeat step 3 to insert the bullet.

You’ve seen the keyboard shortcut, and it’s probably the easiest way to introduce bullet icons into Google Sheets. Let’s go ahead and look at another very convenient method, copy and paste form.

How to insert bullets into Google Sheets (copy and paste method)

An easy way to insert bullets into Google Sheets is to copy them from the source and paste them into your spreadsheet. You can also copy it from here and paste it somewhere in your spreadsheet. You can copy and paste lovely emojis and other unique icons. Also, you can copy a set of different specific icons from the CopyChar website.

 Great! Our work is done. You’ve seen different ways to insert bullets into Google Sheets. That’s what you want. We hope you have learned how to insert bullets into Google Sheets. Check out our many other Google Sheets formulas for creating more complex and valuable functions in Google Sheets.


More from this stream

Recomended