In this tutorial, you will learn how to insert bullet points in Google Sheets.
How to Insert Bullet Points in Google Sheets
Quick Navigation
Sometimes you may want to insert bullet points into your cell values in Google Sheets. Google Sheets has no direct option to add bullet points, but there is a workaround.
By using the CHAR function, you can quickly insert bullet points into your cells in Google Sheets. This can be especially useful when you want to add more structure and clarity to your data.
In this guide, we will show you how to insert bullet points in Google Sheets using the CHAR function.
How to Convert Values to a Bulleted List in Google Sheets
Here’s how to convert values to a bulleted list in Google Sheets.
Step 1
Type ‘=CHAR(8226)’ into an empty cell.
The CHAR function accepts a numerical argument and returns a character that has the same Unicode number as the argument. In this particular case, the bullet character ‘•’ has a Unicode number equivalent to 8226.
Step 2
We can use the ‘&’ concatenate symbol to add text from another cell after the bullet point.
Step 3
Evaluate the function to return text with a bullet point.
Step 4
We can use the Fill Handle tool to convert an entire range of strings into a bullet list.
Step 5
We can also use the keyboard shortcut Alt+Enter to insert a line break. This will allow you to have multiple bullet points inside the same cell.
Summary
This guide should be everything you need to insert bullet points in Google Sheets.
You may make a copy of this example spreadsheet to test it out on your own.