How to Insert Bullet Points in Google Sheets (Keyboard Shortcut + Formula))
Article Link: https://spreadsheetpoint.com/bullet-p...
In this short video, I will show you how to insert bullet points in Google Sheets.
While there is no direct way to insert a bullet point in Google Sheets, there are a few simple workarounds that you can use.
00:00 Intro
00:23 Copy and pasting bullet points
01:23 Using a keyboard shortcut to insert bullet points (ALT + 7)
02:27 Using the CHAR function
04:06 Using Custom number formatting
Each of these methods has its pros and cons and can be used based on how your data is structured.
For example, you can use the formula method to insert bullet points if you have a huge list and you want to quickly convert this list into a bulleted list.
And you can use the shortcut to insert bullet points when you have a small list or you only want the bullet points a couple of ways.
NOTE: To use the shortcut method, you need to have a numeric keypad on your keyboard.
You can read more Bullet Points in Google Sheets: https://spreadsheetpoint.com/bullet-p...
Subscribe to this YouTube channel to get updates on Google Sheets Tips and Google Sheets Tutorials videos - / spreadsheetpoint
This channel is meant for people who want to learn about Google Sheets and be more productive in their day to day life. It covers a range of Google Sheets topics such as useful Google Sheets features, Google Sheets functions, Google Sheets formulas, Pivot table, Google Apps Script,.Shortcuts, Google Sheets Charting, Data Analysis, etc. Please subscribe to this channel and never miss a new video on Google Spreadsheets
You can also find a lot of useful resources on Google Sheets here: https://spreadsheetpoint.com/
#GoogleSheets #GoogleSheetsTips #Spreadsheet