In case you need to conditionally format your bulleted list or apply some formulas to it, say to count specific list items, it is easier to do if the items are normal text entries.To add a bullet symbol to a cell that already contains text, double-click the cell to enter the Edit mode, place the cursor where you want to insert the bullet, and then press Alt + 7 or Alt + 9.On most laptops, this can be done by pressing Shift + Num Lock or Fn + Num Lock. If you are using a laptop that does not have a number pad, you can turn on Num Lock to emulate a numeric keypad.As the result, you will have the entire bullet list in a single cell like shown in the screenshot below: To add multiple bullet points to the same cell, insert the first bullet, hit Alt + Enter to make a line break, and then press one of the above key combinations again to insert a second bullet. To repeat bullet points in non-adjacent cells, select a cell with the bullet symbol and press Ctrl + C to copy it, then select another cell(s) where you want to have the bullets and press Ctrl + V to paste the copied symbol. Once a bullet symbol is inserted into a cell, you can drag the fill handle to copy it to adjacent cells:
![shortcut for bullet points in good shortcut for bullet points in good](https://spreadsheeto.com/wp-content/uploads/2017/08/bullet-symbol.png)
Shortcut for bullet points in good how to#
How to insert bullet points in Excel using keyboard shortcuts
![shortcut for bullet points in good shortcut for bullet points in good](https://img.webnots.com/2019/04/Shortcuts-for-Bullet-Symbols.png)
This would instantly insert a bullet in the cell. Enter the following function in the cell in which you want to insert the bullet.
![shortcut for bullet points in good shortcut for bullet points in good](http://www.outofhoursadmin.ie/wp-content/uploads/2016/09/wingdings-300x222.jpg)
Bullets have the specific Unicode number that can be used within the CHAR function to get a bullet. How to Add Bullet Points in Google Sheets Using the CHAR FunctionĪnother neat way to add bullet points in Google Sheets is to use the CHAR function. Now again hold the ALT key and press the number 7 on the number keypad. If you want to insert multiple bullets in different lines in the same cell, press Alt + Enter to go to a new line in the same cell. This would instantly insert a bullet in the cell in Google Sheets.
![shortcut for bullet points in good shortcut for bullet points in good](https://softwareaccountant.com/wp-content/uploads/2019/11/insert-point-or-bullet-in-Word-img-3.png)
Now the reason could be that the need for bullet points is less in Google Sheets. While there is a simple click option available to insert a bullet in Google Docs, there is no easy way to insert bullets in Google Sheets.