Last Updated on October 31, 2023 by Jake Sheridan
In this tutorial, you will learn how to insert a bullet list in Google Sheets.
How To Insert a Bullet List In Google Sheets
Bullet lists are a great way to present data in an easy-to-read format. However, users may find it difficult to create a bullet list within Google Sheets.
In Google Sheets, there is no built-in way to insert a bullet point. However, you can use the CHAR function to insert a bullet point character or any other character for that matter.
You can also create and apply custom number formatting to add a bullet point to the start of each value. This can be helpful if you want to insert a bullet point across an entire range at once.
In this guide, we will show you how to insert a bullet point in Google Sheets using the CHAR function and number formatting.
How To Add a Bullet List In Google Sheets
Here’s how to add a bullet list in Google Sheets.
First, we’ll explain how to use the CHAR function to add a bullet list in Google Sheets.
In this method, we’ll start with a range of values in a column and create a duplicate copy of the column with the value appended after a bullet point.
The CHAR function allows us to return any character we need and add it to the current cell. The bullet symbol can be retrieved using the function CHAR(8226).
We’ll use the ‘&’ symbol to combine the bullet symbol with the actual value for each bullet point. We’ll also add an empty space “ “ in between to add some distance between the bullet and the list value.
Evaluate the function by hitting the Enter key.
To generate the rest of the list, simply use the AutoFill action using the cursor.
Next, we’ll show you how to use custom number formatting to create a bullet list in Google Sheets.
First, you must select the range you want to convert into a bullet list.
In this example, we want to add a bullet to each value in the range E2:E12.
Next, click on the number formatting icon seen below and select the Custom number format option.
A new dialog box should appear. Clear out any text in the top textbox and enter the string “• @”. Click on Apply to proceed.
The ‘@’ symbol is used as a placeholder for text. The custom number format syntax indicates that the text will be placed after a bullet point.
You should now have a range formatted as a bullet list in Google Sheets.
We may also use keyboard shortcuts to insert a bullet point manually for each value in a list.
First, select an empty cell where you want to place the first bullet point.
Next, click on the Alt key and hit the ‘7’ in your numeric keypad. A bullet should now appear in the current cell.
This guide should be everything you need to insert a bullet list 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
- Make a Numbered List
- Insert Bullet Points
- 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