![Bullet point for mac Bullet point for mac](/uploads/1/1/9/8/119877478/985455119.png)
Since Google Sheets is a spreadsheet application and bullet points are rarely needed, the option to create them was left out from the toolbar. However, Google Sheets does include support for bullet points.
To add a sub-bullet list, press return and then press Tab. This will change the bullet’s appearance and indent it. When you’re done with the sub-bullet list and want to return to the main bullet list, press Shift-Tab. Below is a minute-long video demonstrating all of these features. First I type three items. Use animation in PowerPoint to show a list of bullet points one at a time or have the bullet points appear automatically after a short interval. Choose a motion effect for how each bullet point appears.
There are two ways to add a bullet point to a cell in Sheets.
Pages detects when you’re typing a list and adds some basic formatting as you type. In your document, place the insertion point where you want the list to begin. Type a dash, a bullet (Option-8), or a letter or number followed by a period and a space (such as 1. Followed by a space). Occasionally web developers, editors, and publishers need to quickly copy and paste bullet points, funky fonts, and symbols. Below you will find a large selection of of characters to choose from.
Using a shortcut
On PC: Hold the ALT key and press 7 (on the numeric keyboard)
You can also follow with ALT + ENTER to insert a line break if you wish to add multiple bullet points inside the same cell.
On Mac: Hold the OPTION key and press 8
Follow with CONTROL + OPTION + ENTER to insert a line break.
Using a formula
The CHAR function in Sheets returns the character specified by the code number.
Keyboard Shortcut Bullet Point Mac
Paste the following formula in the cell in which you wish to add a bullet point:
Bullet Points For Achieves
=CHAR(9679)
Bullet Points Mac 10.13.6
If you want to create a bullet point list, you can drag handle to the other cells and the formula will follow.