Last Updated on October 31, 2023 by Jake Sheridan
In this tutorial, you will learn how to insert bullet points in Google Sheets.
How to Insert Bullet Points in Google Sheets
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.
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.
We can use the ‘&’ concatenate symbol to add text from another cell after the bullet point.
Evaluate the function to return text with a bullet point.
We can use the Fill Handle tool to convert an entire range of strings into a bullet list.
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.
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.
More ways to use text in Google Sheets:
- Add Bullet Points
- Insert Text Box
- Insert Special Characters
- Insert Symbols
- Insert Page Break
- Center Text
- How To Make Text Fit In Cell
- Make Text Vertical
- Change Case
- View Page Breaks
- Line Break In Google Sheets
- How To Capitalize
- How To Wrap Text
- How To Indent
- Count Cells with Text
- Fit Text to Cell
- Checking if a Cell Contains a Substring
- TEXT Function
- Combine Text From Two Cells
- SUMIF Cells If Contains Text
- Add Text To Formula
- Indent Text
- Change Text To All Caps
- Spell Check in Google Sheets
- How to Use Spell Check
- Insert a Bullet List
- Make a Numbered List
- Add a New Line In Cell
- Add Multiple Lines In One Cell
- Wrap Text In Cell
- Superscript In Google Sheets
- Make A Degree Symbol
- SUBSTITUTE Function
- How To Alphabetize