Download Article
Insert a bullet into your Google Sheets document with one of these three methods
Download Article
For some reason, Google Sheets does not include the button found in both Google Docs and Google Slides that creates a bulleted list. Despite this, there are a few workarounds you can use to quickly add bullet points to your spreadsheet. This wikiHow article will teach you how to insert bullets into cells in Google Sheets.
Things You Should Know
- Press Alt+7 on Windows or Option+8 on Mac to insert a bullet point in a Google Sheets cell.
- Use the CHAR function by typing =char(9679) in to a cell to insert a bullet point.
- Copy a bullet from somewhere else, such as an internet page, and paste it into your Google Sheets.
Steps
-
Open a Google Sheet. You can open an existing Google Sheet or create a new one at https://drive.google.com/drive/u/0/my-drive .
-
Double click on a cell or press F2 after clicking a cell to enable edit mode for the cell. The selected cell should now be outlined in blue with a blinking cursor inside cell.Advertisement
-
Press and hold Alt and press 7 for Windows or ⌥ Option + 8 for Mac. This keyboard shortcut will create a bullet point in your cell. [1] X Research source
- To quickly add bullet points to other cells, click and drag the blue square in the bottom-right corner of the bulleted cell, then let go once you have covered the desired number of cells.
- If you would like to make a bulleted list in a single cell, create a new line by pressing Alt + Enter for Windows or Option + Return for Mac, then create another bullet. Repeat this sequence until you have the right number of bullets.
Advertisement
-
Open a Google Sheet. You can open an existing Google Sheet or create a new one at https://drive.google.com/drive/u/0/my-drive .
-
Click on a cell. The selected cell should now be outlined in blue.
-
Type =char(9679) and hit ↵ Enter or ⏎ Return . CHAR is a function in Google Sheets that imports a specific character from a table, and 9679 is the cell that corresponds to a bullet point.
- To quickly add bullet points to other cells, click and drag the blue square in the bottom-right corner of the bulleted cell, then let go once you have covered the desired number of cells.
Advertisement
-
Search the web for bullet points . You will be able to copy and paste many of the bullet points you find online directly into your Google Sheets.
-
Find a website that lists bullet point icons. There are many sites that provide lists of unicode characters. Unicode is a system that assigns a specific number to a character so it will be the same across all platforms. In this case, using Unicode bullet points ensure that they will be visible on any device you use.
-
Copy the desired bullet point. You can copy a bullet point by highlighting it, then pressing Control + C on Windows or Command + C on Mac. Alternatively, you can right-click the highlighted bullet, then select Copy .
- Some sites have created buttons that will automatically copy a bullet for you once you click on it.
-
Open a Google Sheet. You can open an existing Google Sheet or create a new one at https://drive.google.com/drive/u/0/my-drive .
-
Click on a cell. The selected cell should now be outlined in blue.
-
Paste your bullet point into the cell. You can paste your bullet by pressing Control + V on Windows or Command + V on Mac, or by right-clicking inside the cell, then selecting Paste .
- To quickly add bullet points to other cells, click and drag the blue square in the bottom-right corner of the bulleted cell, then let go once you have covered the desired number of cells.
- If you would like to make a bulleted list in a single cell, create a new line by pressing Alt + Enter for Windows or Option + Return for Mac, then paste another bullet. Repeat this sequence until you have the right number of bullets.
Advertisement
Expert Q&A
Ask a Question
200 characters left
Include your email address to get a message when this question is answered.
Submit
Advertisement
Tips
- While the keyboard shortcut method will not work on mobile devices, both the CHAR function and the copy-paste method will successfully add bullet points.Thanks
Submit a Tip
All tip submissions are carefully reviewed before being published
Name
Please provide your name and last initial
Thanks for submitting a tip for review!
Advertisement
About This Article
Article Summary
X
1. Open a Google Sheet and select a cell.
2. Press Alt
+ 7
on Windows or Option
+ 8
on Mac.
3. Alternatively, type =char(9679)
and hit Enter
or Return
.
4. Lastly, look up bullet points and copy the desired icon, then paste it into the cell.
Did this summary help you?
Thanks to all authors for creating a page that has been read 15,050 times.
Advertisement