How to Add Bullet Points in Google Sheets

The spreadsheet is not only used to capture and maintain the accounting number values but also to track the day-to-day activities, assigned tasks, etc, and for the same users can create task lists and checklists for the activities.

And the best way of creating the list is by adding the bullet points at the beginning of each task in the list.

In this tutorial, we will show you multiple ways of adding bullet points in Google Sheets.

Insert Bullet Points Using CHAR function

Using the CHAR function is a quick and fastest way of adding bullet points. It also provides the option of adding large or small bullet points by just applying the different available codes.

With the help of the CHAR formula, you can add large and small bullet points whichever you want to add, using the different CHAR codes.

• First, go to the cell, where you want to add a bullet point.
• After that, enter the CHAR function “=CHAR(9679)”  for large bullet points or “=CHAR(8226)”  for small bullet points within the cell.
• Once you enter with the formula, press enter and your formula will also get applied to the rest of the cells.

=CHAR(9679)&" "&A2
=CHAR(8226) )&" "&A2

Insert Bullet Points Using Alt Code

For those who know how to use the Alt codes to add different kinds of signs and symbols, it can be considered the fastest way of adding bullet points.

• First, go to the cell and double-click on it to activate the cell in edit mode.

• After that, press and hold the “Alt” key and then enter (0149) and it will add the bullet point as shown below.

• Now, come out of the edit mode and double-click on the fill handle icon and the bullet point will get copied to the rest of the checklist items.

• Finally, use the ampersand (&) to combine the bullet points and text columns.

=A2&" "&B2

Use Custom Formatting for Bullet Points

If you often create checklists, instead of adding the bullet points manually every time, you can create a custom formatting that will add bullet points automatically whenever you create a checklist. You just need to select that custom formatting before creating the checklist.

• First, go to the “Format” tab and then hover the mouse on “Number” and then click on “Custom number format”.

• In the custom number formats dialog box, enter the bullet point, followed by @ symbol within the input bar, and click “Apply”.
• At this point, you have successfully created the custom formatting to add bullet points and is ready for use.

• Now, select the range where you want to create the checklist, go to the “Format” tab, hover the mouse over “Number,” and click on the custom formatting you just created in the above step.

• When you enter a value within the selected range, bullet points will get added automatically.

Copy and Paste Bullet Point in Google Sheets

You can also copy the bullet point character online or offline and can paste it into Google Sheets.