Basics

Using the SORT Function in Google Sheets (With Examples)

The SORT function in Google Sheets is a fundamental, yet very handy function to know about. And we are going to be breaking down its uses in this ...

SORT Function for Multiple Columns in Google Sheets

Today, we will look at how we can use the SORT function to sort for multiple columns in Google Sheets. We will look at different use cases that are ...

How to Sort Numerically in Google Sheets (3 Ways)

Today, we will look at the different ways to sort numerically in Google Sheets. We will be using both in-application options and functions to achieve ...

How to Sort by Multiple Columns in Google Sheets (3 Ways)

Today, we will look at how to sort by multiple columns in Google Sheets. While most users will think about the Sort Range option, which we will be ...

How to Sort Alphabetically in Google Sheets (3 Ways)

Knowing how to sort alphabetically in Google Sheets is a fairly simple deal. However, if something seems simple it usually means that there are ...

Find Cell Reference in Google Sheets (2 Ways)

Today, we will look at a couple of ways with which we can find cell references in Google Sheets, focusing on the ones that can be found in formulas. ...

Relative Cell Reference in Google Sheets

Understanding relative cell reference in Google Sheets. or any other spreadsheet application, is considered a starting point for any aspiring user. ...

Variable Cell Reference in Google Sheets (3 Examples)

Today, we will look at the different scenarios where we use a variable cell reference in Google Sheets. While the idea is simple, utilizing it can ...

Reference Another Tab in Google Sheets (2 Examples)

Today, we will look at a couple of different scenarios where we reference another tab in Google Sheets spreadsheets. Knowing how to reference another ...

Reference Cell in Another Sheet in Google Sheets (3 Ways)

Today, we will look at all the ways we can reference cell in another sheet in Google Sheets. We will first touch on the fundamentals of referencing ...

How to Query Cell Reference in Google Sheets

Today, we will look at how we can apply a query cell reference in Google Sheets. To give a better understanding, we will use multiple scenarios and ...

Return Cell Reference in Google Sheets (4 Easy Ways)

Today, we will look at all the ways to return cell reference in Google Sheets. We will utilize some functions that are not often used in day-to-today ...

Indirect Sheet Name in Google Sheets (Easy Steps)

In this article, we will look at how we can use an indirect sheet name in Google Sheets. This helps to refer to multiple sheets, all the while ...

Indirect Range in Google Sheets (3 Easy Ways)

Today, we will look at how to pull data from an indirect range in Google Sheets. Just a disclaimer, this article focuses on cell ranges, not values ...

Cell Reference From String in Google Sheets

Today, we will look at how to get cell reference from a string in Google Sheets. Our main methods revolve around the INDIRECT function. We have also ...

OfficeWheel
Logo