Basics

Match from Multiple Columns in Google Sheets (2 Ways)

Today, we will look at how to perform a match from multiple columns in Google Sheets. This process is useful if you want to extract values based on ...

INDEX-MATCH with Multiple Criteria in Google Sheets (Easy Guide)

We are already aware of how powerful the INDEX-MATCH combination is when extracting data in Google Sheets. If not, please visit our Using INDEX MATCH ...

How to Use Find and Replace in Column in Google Sheets

Find and Replace can be quite a powerful tool when used in large documents. Its uses are many and, in this article, we will look at how to use Find ...

Easy Guide to Replace Formula with Value in Google Sheets

While formulas are the backbone of any professional spreadsheet, I can sometimes be wise to replace formula with raw value in Google Sheets if ...

How to Use Conditional Formatting in Google Sheets

Today we will have a look at how to use conditional formatting in Google Sheets, which is potentially one of the most used built-in functions by any ...

Copy Formatting From One Sheet To Another In Google Sheets (2 Ways)

Knowing how to copy formatting comes in handy especially when you have multiple worksheets or spreadsheets that have a similar data layout. It will ...

Conditional Formatting with Checkbox in Google Sheets

Today, we will look at how we can use Conditional Formatting with a Checkbox in Google Sheets. Conditional Formatting and Checkboxes are widely used ...

Google Sheets: Conditional Formatting with Multiple Conditions

When we think about multiple conditions, the first thing that comes to mind is its logical formatting. So it comes to no surprise that when creating ...

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

How to Copy Conditional Formatting in Google Sheets

Today, we will look at two very easy ways to copy conditional formatting in Google Sheets step-by-step. We will also see how we can apply these ...

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

OfficeWheel
Logo