Google Sheets Tips
Here’s how to count colored cells in Google Sheets. I have a full video guide and a written guide with step-by-step instructions and screenshots below. I’m also including a powerful…
There are a few easy ways to zoom out on Google Sheets. These methods also allow you to zoom in. This guide shows where to find the view menu and…
To highlight duplicates in Google Sheets, use conditional formatting and the COUNTIF function. My guide below covers this in detail. Specifically, I’ll show how to use conditional formatting to highlight…
Adding a Google Sheets hyperlink is a piece of cake. This guide will show you how to do it with 3 different methods as well as how to edit and…
To hide gridlines in Google Sheets, use the “show” menu. I’ll show where to find this (and how to add only specific lines in your spreadsheet) below. Note that my…
To add a drop down list in Google Sheets, use the insert menu or right click on a cell. The process differs a little from Excel. But rest assured, I’ll…
A Google Sheets heat map is a great way to add color to a boring spreadsheet, making it much easier to read and more visually appealing. Luckily, Google Sheets has…