How To Put Bullet Points In Google Sheets

by

Using bullet points in Google Sheets can help make your data easier to read and digest. Though not as straightforward as in Google Docs or Slides, using bullet points in Google Sheets is still a simple process once you know how to do it. In this blog post, we will guide you step-by-step on how to insert bullet points into your Google Sheets.

Method 1: Using the CHAR function

The CHAR function in Google Sheets is used to return the character corresponding to the decimal Unicode value provided. The Unicode for the standard bullet point (•) is 8226. Therefore, to insert a bullet point in Google Sheets, you can use the CHAR function as follows:

=CHAR(8226)

Method 2: Using Alt Codes

If you’re using a Windows device, you can use alt codes to insert bullet points directly into your Google Sheets. Here’s how:

  1. Click on the cell where you want to insert the bullet point.
  2. Press and hold the Alt key on your keyboard.
  3. While holding down the Alt key, type 0149 on the numeric keypad.
  4. Release the Alt key, and you should see a bullet point inserted in your selected cell.

Method 3: Copy and Paste

Another way to insert bullet points into your Google Sheets is by copying them from another source and pasting them into your sheet. If you’re using a Mac, the bullet point shortcut is Option+8. After pressing this, you can copy the bullet point and paste it into your Google Sheets document.

Method 4: Using a Formula

You can also insert bullet points using a formula. Suppose you want to add bullet points in front of every item in your list. For example, if you have a list in column A and you want to add bullet points to all the items, you can use the formula:

=CHAR(8226)&" "&A1

This formula will add a bullet point and a space in front of the item in cell A1. You can then drag the fill handle (the small square at the bottom-right of the cell) down to apply the formula to the rest of the list.

Conclusion

This blog post has explained several methods to insert bullet points in Google Sheets. Whether you prefer using the CHAR function, alt codes, copy and paste, or a formula, all these methods are effective ways to make your spreadsheet more organized and easier to read. Try them out and see which one works best for you!