Formulas

Google Sheets: Conditional Formatting Row Based on Cell

Conditional formatting is quite a versatile function in any spreadsheet application. And today we will see the conditional formatting of a row/rows ...

Using Conditional Formatting With Custom Formula in Google Sheets

Today we will look at how we can use conditional formatting with custom formula in Google Sheets. Let’s get started. Basics of Using Custom ...

How to Apply a Custom Sort in Google Sheets

It is not uncommon that a spreadsheet user may need to apply custom conditions for sorting and organizing data. Understanding that, we will look at ...

Sort by Row in Google Sheets (2 Basic Ways)

There are no definite or built-in ways to sort by row in Google Sheets. All we can do is look for workarounds to sort this unique arrangement of ...

How to Sort by Value in Google Sheets (With Examples)

In this article, we will look at all the ways in which we can sort by value in Google Sheets. Let’s get started. The 2 Types of Values that ...

How to Sort by Number in Google Sheets (4 Ways)

In this article, we look at a few ways in which we can sort by number in Google Sheets. To fully cover everything, we have used multiple approaches ...

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 ...

OfficeWheel
Logo