Google Sheets Tips
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…
To clear formatting in Google Sheets, use the dropdown menu or a keyboard shortcut. I’ll show both methods in this guide. Clear Formatting in Google Sheets When working with data…
To assign a task in Google Sheets, either tag someone’s email in a comment or create a drop-down list. I show both methods in this guide. The commenting method is…
To count cells with text, you’ll need to use a specific function. This can be done with either COUNTA or COUNTIF. However, note that the COUNTIF function only counts cells…
To split cells in Google Sheets, highlight the cell, select the “data” menu, and click “split text to columns”. Otherwise, use the SPLIT function. I’ll demo both in my guide…
How do you extract a URL from a hyperlink in Google Sheets? As someone who deals with a lot of spreadsheets, I often find myself dealing with many hyperlinks. Although…