Basics

Google Sheets: Use Cell Value in a Formula (2 Ways)

Today we will look at how we can use cell value in a formula in Google Sheets. The general idea revolves around cell references, but we will go the ...

Dynamic Cell Reference in Google Sheets (Easy Examples)

Today, we will go through an in-depth guide of how to use a dynamic cell reference in Google Sheets, for both within the same worksheet or reference ...

Protect Range in Google Sheets (Easy Examples)

Today, we will look at how to use the Protect Range option in Google Sheets. We shall implement it for two scenarios: the first for a range of cells ...

Protect Sheet From View in a Google Spreadsheet (2 Ways)

Today we will be looking at the ways to protect a sheet from view in a Google Sheets spreadsheet. The idea and process are simple but very important ...

How To Lock Rows In Google Sheets (2 Easy Ways)

Today, we will look at how to lock rows in Google Sheets in two different ways. First, the basic way with Protect Range option and the other, more ...

Conditional Locking Of Cells In Google Sheets (Easy Steps)

You can never get enough protection for your crucial spreadsheets. To that end, we believe, you can’t get any safer than the conditional locking of ...

How to Lock a Column in Google Sheets (Simple Examples)

Today, we will look at how to lock a column in Google Sheets in the most basic way available to us in the application. As an extra situational ...

How to Use SUMIF in Google Sheets (With Examples)

SUMIF in Google Sheets is one of the core functions in the spreadsheet software. Its application is numerous, of which we will be seeing more of in ...

Count Non-Empty Cells in Google Sheets (4 Easy Ways)

The ability to recognize and count non-empty cells in Google Sheets is very crucial if you are looking to avoid some silly errors. And today, we will ...

How to Search in Google Spreadsheet (5 Easy Ways)

Google Sheets allows us to perform searches for data and values in many different ways. So today, in this article we look at how to search in Google ...

How to Sort by Date in a Google Spreadsheet (2 Ways)

Today we are going to be looking at two separate ways of how we can sort by date in a Google Sheets spreadsheet. The processes are fairly simple ...

Reference Another Sheet in Google Sheets (4 Easy Ways)

Today, we look at how to reference another sheet in Google Sheets. While it does sound easy (and it is), it’s common to see users of all levels of ...

Using INDEX MATCH in Google Sheets – A Deep Dive

Today, we will look at the use of INDEX MATCH in Google Sheets. This amazing combination of functions is available in both Excel and Google Sheets. ...

Find and Replace in Google Sheets (3 Ways)

Find and Replace is an indispensable tool provided by Google Sheets. If you are thinking of the simple Find option, then you couldn’t be further away ...

How to Freeze Rows in Google Sheets (3 Ways)

In professional work, we are often asked to tackle worksheets that have large amounts of data. In such cases, it is imperative that we freeze up our ...

OfficeWheel
Logo