How to Insert Bullet Points in Google Sheets

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

Method #1: OPTION+8/ALT+7

How to Insert Bullet Points in Google Sheets Method 1

First, you can use a keyboard shortcut to insert a bullet point.

for Mac, use OPTION+8

for PC, use ALT+7

Method #2: “=CHAR(9679)”

How to Insert Bullet Points in Google Sheets Method 2You 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"}

Google Sheets Magic Tricks!

Interactive, Easy and Free Way to Learn 5 Awesomely Cool Google Sheets Tricks!