Google Sheets Tips

Sometimes, I need to select more than one item in a drop-down list in my spreadsheet. It’s not a built-in function. So how do you do it? I’ll show you how to make multiple selection drop-d...
To highlight duplicates in Google Sheets, use conditional formatting and the UNIQUE function. This guide includes step-by-step instructions....
Adding a Google Sheets hyperlink is easy. Follow this guide to learn 3 different ways to do it in asa little as a few seconds....
To import Stock Prices into Google Sheets, use the File menu and select import. Then, upload your CSV file. Here’s a video I made that shows the whole process. Where to Find Historical Stock Pri...
To calculate age in Google Sheets, use the DATEDIF or YEARFRAC formulas. Follow along for screenshots and full formula explanations....
Here's how to hide gridlines in Google Sheets with the view menu or the print menu. The guide also shows how to show lines in specific cells....
To make a Google Sheet drop down list, use the insert menu or right click. This guide also covers data validation in drop downs menus....
Learn how to make a single-color, multi-color, and Geo Google Sheets heat map in a few clicks with this comprehensive step-by-step guide....
To clear formatting in Google Sheets, use the dropdown menu or a keyboard shortcut. This guide covers both methods with a step-by-step how to....