What Are Bullet Points In Google Sheets?
Bullet Points in Google sheets, as the name suggests, is the method to add bullet points in Google sheets. It is easy to add bullet points in Google docs but to insert bullet points in Google sheets, we need to use certain easy steps.
Users can use keyboard shortcuts, custom number formats, functions like CHAR function, special characters tool or by using copy-paste method to insert bullet points in Google sheets. For example, consider the below table showing a proverb in cell A2.
Now, let us learn how to insert bullet points in Google sheets.
To start with, select the cell A1 and press Alt key. Then, select 7 and release both the keys at once.
We will be able to see the result in cell A2 as shown in the below image.
Likewise, we can insert bullet points in Google sheets.
In this article, let us learn how to use and insert bullet points in Google sheets with detailed examples.
Table of Contents
Key Takeaways
- Bullet points in Google sheets is nothing but a method used to insert bullet points in Google spreadsheets data.
- Unlike Google documents, we cannot insert bullet points by pressing the keyboard keys Shift +* in Google sheets.
- To include, we need to use the shortcut keys Alt +7 to insert bullet points in Google sheets.
- Similarly, we can also use the copy-paste method or use any of the methods discussed such as the special characters method in Google sheets to insert bullet points in Google spreadsheets.
How To Insert Bullet Points In Google Sheets?
We can insert bullet points with the following methods.
- Using keyboard shortcut
- Applying custom number formats
- Utilizing the CHAR function for bullets
- Copy and paste bullet points
- Using the special characters tool
In this article, let us learn how to insert bullet points in Google sheets with examples.
#1 – Using Keyboard Shortcut
For example, consider the below table showing groceries list and with bullet marks in columns A and B, respectively.
Now, let us learn how to insert the bullet points using keyboard shortcut method.
The steps are:
Step 1: To begin with, we need to insert the data in the spreadsheet. In this example, the data is available in the cell range A1:B2. Next, we need to select the cell where we want to insert the bullet points and double click the click to enter into edit mode. So, in this example, we need to select the cell B2 and double click on it.
Step 2: Next, press the Alt key and while holding it, press 7 in the keyboard.
Step 3: Release both the keys at the same time.
We will be able to see the result with bullet points in the cell B2, as shown in the below image.
Likewise, we can use the keyboard shortcut method to insert bullet points.
#2 – Applying Custom Number Formats
For example, consider the below table showing names of students in columns A.
Now, let us learn how to insert the bullet points by applying custom number formats.
The steps are:
Step 1: To begin with, we need to insert the data in the spreadsheet. In this example, the data is available in the cell range A1:A6. Next, we need to select the cell or the cell range where we want to insert the bullet points. So, in this example, we need to select the cell range A2:A6.
Step 2: Next, select Format and click on Numbers in the list of options. Under the Number drop down, click on Custom Number Format option, available at the bottom of the drop-down menu.
Step 3: The Custom Number Formats window opens up.
Here, enter → @ in the text bar and press on Apply.
We will be able to see the result with bullet points in the cell range A2:A6, as shown in the below image.
Likewise, we can use the keyboard shortcut method by applying custom number formats to insert bullet points in Google sheets.
#3 – Utilizing The CHAR Function For Bullets
For example, consider the below table showing a bird name in cell A2.
Now, let us learn how to insert the bullet points in Google sheets by using CHAR Function in Google sheets.
The steps are:
Step 1: To begin with, we need to insert the data in the spreadsheet. In this example, the data is available in the cell range A1:B2. Next, we need to select the cell where we want to insert the bullet points. So, in this example, we need to select the cell B2.
Step 2: Next, insert the CHAR function in Google sheets.
Step 3: By default, the number associated to the bullet point is 9632.
So, we need to enter the value as shown in the below image.
Step 4: Now, we need to add a space between quotation marks. So, we need to include the symbols, &” “& in the formula, as shown in the below image.
Step 5: Finally, we need to include the cell reference. Therefore, we need to add the cell reference A2 in the formula.
So, the complete formula is =CHAR(9632)&” “&A2, as shown in the below image.
Step 6: Press Enter key.
We will be able to see the result in cell B2, as shown in the below image.
Likewise, we can use the CHAR function in Google Sheets to insert bullet points.
#4 – Copy And Paste Bullet Points
We can easily copy and paste the bullet points. Especially, when we have pre-existing data in Google docs with bullet points, we can easily copy them and paste them in the Google spreadsheets.
The steps are:
Step 1: We need to highlight the text with the bullet points in Google Docs.
Step 2: Next, press Ctrl + C and copy the content.
Step 3: Open the Google spreadsheets. Now, press the shortcut keys, Ctrl + V to paste the bullet points.
By this way, we can copy the content with bullet points, as shown in the below image.
Likewise, we can use the copy and paste bullet points method to insert bullet points.
#5 – Using The Special Characters Tool
This is one of the methods used to insert bullet points with the help of special characters. To use this method, we need to use the below steps.
- Step 1: To begin with, open Google documents and select blank document.
- Step 2: Next, we need to select Insert and click on Special Characters.
- Step 3: Now, choose a symbol and click on Geometric shapes. Here, we need to select the symbol. We can copy the content by pressing the shortcut keys Ctrl + C.
- Step 4: Finally, copy the content in the Google spreadsheets.
We will be able to insert the bullet points.
Likewise, we can use the special characters tool method to insert bullet points.
In this article, we learned different methods to insert bullet points in Google sheets with examples.
Important Things To Note
- Bullet points in Google sheets is a method used to insert bullet points in Google sheets.
- Remember, we can add bullet points easily in Google documents. But we cannot insert bullet points directly in Google sheets.
- Therefore, we need to use one of the following methods. They are:
- Using keyboard shortcut
- Applying custom number formats
- Utilizing the CHAR function for bullets
- Copy and paste bullet points
- Using the special characters tool
Frequently Asked Questions
For example, consider the below table showing health proverb bullet marks in column A.
Now, let us learn how to insert the bullet points in Google sheets using keyboard shortcut method.
The steps are:
Step 1: To begin with, we need to insert the data in the spreadsheet. In this example, the data is available in the cell range A1:A2. Next, we need to select the cell where we want to insert the bullet points and double click the click to enter into edit mode. So, in this example, we need to select the cell B2 and double click on it.
Step 2: Next, press the Alt key and while holding it, press 7 in the keyboard.
Step 3: Release both the keys at the same time.
We will be able to see the result with bullet points in the cell A2, as shown in the below image.
Likewise, we can use the keyboard shortcut method to insert bullet points in Google sheets.
Simply double click on the cell and press the shortcut keys Alt + 7 and release both the keys simultaneously. We will be able to see the bullet points in the selected cell reference.
CHAR function in Google sheets formula is =CHAR(table_number) where table number is the only mandatory argument.
The table_number argument shows the unique code associated with the character.
Remember, to use CHAR function to insert bullet points in Google sheets, we need to add the symbols, &” “& and insert the cell reference in the below format.
The format is =CHAR(table_number)&” “&cell_reference
Recommended Articles
Guide to What Are Bullet Points In Google Sheets. Here we discuss how to insert bullet points in different ways with examples & a working template. You can learn more from the following articles.
MATH Functions In Google Sheets
Conditional Formatting Based On Another Cell In Google Sheets
Leave a Reply