How to Get Bullet Symbols in Google Sheets For both, you must first know how to get bullet symbols. After that, I will explain how to create your bulleted list in Google Spreadsheets using either a formula or custom formatting. But that way you can insert only 2-3 bullet points and may not support all the PC.įirst I am going to give you all the essential bullet points in Google Sheets. There is one more approach involving the Alt+ numeric keypad numbers. I have two approaches – formula as well as custom formatting based approaches. Here are the workaround to insert white and black (filled and unfilled) bullet points and other essential bullets/symbols in Google Sheets. I have used this function earlier to get Subscript/Superscript letters and numbers in Google Sheets.
Now regarding the CHAR function, you may not be new to this. As mentioned, there are the CHAR function, custom formatting, and some keyboard shortcuts to insert Bullet Points in Google Sheets. That doesn’t mean we are left with no options. So we can’t complain about not having a menu option to insert Bullet Points in it. Google Sheets is a Spreadsheet application, not a word processor. I recommend the custom formatting based bullet list-making in Google Sheets as it doesn’t involve any physical character at the beginning of the bullet list.
Another method is using Custom formatting (recommended). The easiest way to insert bullet points in Google Sheets is by using the CHAR function. At present, the Bullet list is not part of the Google Sheets menu.