How to create bullet points in Google Sheets
However, if you want to insert bullet points, Google Sheets is also very simple, such as using keyboard shortcuts. Using the function in Google Sheets to create bullet points is also an easy-to-use function that is not complicated. The following article will show you how to create bullet points in Google Sheets.
Insert bullet points in Google Sheets with keyboard shortcuts
In the cell you want to insert a bullet point, hold down the Alt key and then press the number 7 . Soon you will see a bullet point.
How to create bullet points in Google Sheets Picture 1
In case you want to create a list in a Sheets cell , we will use the ALT + Enter key combination to enter a line break in the same cell.
How to create bullet points in Google Sheets Picture 2
Then we insert bullet points for each content in 1 cell.
How to create bullet points in Google Sheets Picture 3
Insert bullet points with the CHAR function Google Sheets
In the cell where we want to insert a bullet point, we enter the function formula =CHAR(8226) .
How to create bullet points in Google Sheets Picture 4
The result also shows a dot icon as shown below.
How to create bullet points in Google Sheets Picture 5
Next we will combine the CHAR function with the content cell to form the list we need. You enter the function formula =CHAR(8226)&" "&D46 where D46 is the reference cell with the content you want to create a bullet point.
How to create bullet points in Google Sheets Picture 6
When you press Enter, the content will be added a bullet point. Now you just need to drag the first cell down to the other to add a bullet point in Google Sheets.
However, with this method, you are forced to create a new column to create bulleted content.
How to create bullet points in Google Sheets Picture 7
Google Sheets bulleted custom formatting
Step 1:
Select the cells where you want to add a bullet point. Next, click on Format and then click Number below. Next click on Custom Number Format .
How to create bullet points in Google Sheets Picture 8
Step 2:
Display the interface so that we can adjust the format to our liking. You find the style .@ and then press Apply to create a bullet point.
How to create bullet points in Google Sheets Picture 9
As a result, we have a list as shown below.
How to create bullet points in Google Sheets Picture 10
If you don't like the . then you can enter another mark to use. The @ symbol represents what you type. For example, use the - sign before the content in Excel you will enter - @ and then press Apply.
How to create bullet points in Google Sheets Picture 11
As a result we will see a list with the - icon in front of the content.
How to create bullet points in Google Sheets Picture 12
You should read it
- How to add bullet in Google Sheets
- How to Create a Bullet Point
- How to Create a Bullet Point in Microsoft Applications
- How to create graphs, charts in Google Sheets
- Tricks using Google Sheets should not be ignored
- How to create a phone number can be called on Google Sheets
- Create bullets using Bullets in PowerPoint
- How to insert checkboxes on Google Sheets
- How to set up the right to edit spreadsheets on Google Sheets
- How to align spreadsheets before printing on Google Sheets
- How to create a custom map in Google Sheets
- How to insert Google Sheets spreadsheets into Google Docs