Inserting bullet points in Google Sheets is a pretty useful trick that not many people know how to do. That is the goal of this article; to teach you how to paste bullet points into Google Sheets and make a bullet point list.

How to Insert Bullet Points in Google Sheets

In this article, I will show you how to insert bullet points in any table on Google Sheets. There are two main techniques that we will go over to add bullet points in google sheets. There are keyboard shortcuts, as well as an on-page function.

The first method to add bullet points to add bullet points to any google sheet involves a keyboard shortcut.

Method #1: Option+8

How to Insert Bullet Points in Google Sheets Method 1

First, you can use a keyboard shortcut to insert a bullet point into the same cell you have selected.

for Mac, use OPTION+8

for PC, use ALT+7

Method #2: =CHAR(9679)

The second method for adding multiple bullet points is calling the CHAR code.

How to Insert Bullet Points in Google Sheets Method 2
You can also use the CHAR function to input the special bullet point character.

in the function window, type "=CHAR(9679)" that will input the bullet point character to that cell.

if you want to add bullet points to the cell, simply press OPTION/ALT+7, and a new line will be created within that cell.

And there you have it; that is how you insert bullet points in Google Sheets.

Leave a Reply

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

{"email":"Email address invalid","url":"Website address invalid","required":"Required field missing"}