Google Sheets Tips
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…
A box plot in Google Sheets can provide a valuable way to visualize the distribution of data. It lets you summarize important details of a set of data at a…
There’s a simple way to spell check in Google Sheets. Below, I’ll show you where to find it and how to make the most of it. Note that this differs…
Do you need to hide zero values in Google Sheets? You’re in the right place. Sometimes, your data set looks cluttered with a bunch of zero values. That might be…
Do you want to incorporate the artificial intelligence tool Chat GPT into Google Sheets? While there is no official Chat GPT for Sheets add-on, plenty of third-party apps will allow…