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.
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.
Then we insert bullet points for each content in 1 cell.
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) .
The result also shows a dot icon as shown below.
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.
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.
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 .
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.
As a result, we have a list as shown below.
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.
As a result we will see a list with the - icon in front of the content.
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
Maybe you are interested
Close-up of bullet shattering when fired at 'fragile' pendulum system
Close-up of a mantis shrimp's punch stronger than a bullet, killing a mud crab in the blink of an eye
How fast is the bullet fired from the gun?
Guide bullet points in Excel
What is Bullet Journal?
Polycarbonate Sheet: What Do People Use This Bulletproof Material For?