Basics

How to Freeze Columns in Google Sheets (3 Ways)

In today’s article, we will be looking at how to freeze columns in Google Sheets. Know that the processes are basic and can be used by users of ...

How to Unmerge Cells in Google Sheets (4 ways)

Whether it be personal or for data cleanup and organization reasons, knowing how to unmerge cells in Google Sheets is crucial. And that is exactly ...

How to Merge Cells In Google Sheets Without Losing Data

Sometimes, the traditional ways to merge cells in google sheets may not cut it, thanks to the wiping of data that happens with the built-in function. ...

How to Merge Columns in Google Sheets

Knowing how to merge columns in Google Sheets is a fairly easy affair. But things can get complicated when a lot of data and specific criteria are ...

How to Wrap Text in Google Sheets (4 Ways)

In this article, we will learn how to wrap text in Google Sheets, which is one of the fundamental functions of the application. 4 Ways to Wrap Text ...

Conditional Formatting with Multiple Conditions Using Custom Formulas in Google Sheets

As complex as custom formulas can be, they are a lifesaver when working with spreadsheets that contain large amounts of data. On the other hand, you ...

Conditional Formatting Based on Another Cell in Google Sheets

Conditional formatting is a powerful tool in any spreadsheet application. It helps highlight important data in your worksheet no matter how complex ...

Using COUNTIF to Count Non-Blank Cells in Google Sheets

Counting non-blank cells in a spreadsheet is a fairly common affair at every level of the profession. There are many ways to go about it. But today, ...

COUNTIF Across Multiple Sheets in Google Sheets

The COUNTIF function is a fairly basic function in both Excel and Google Sheets. But that doesn’t mean its applications are basic as well. In this ...

COUNTIF Contains Text in Google Sheets (4 Ways)

In a practical scenario, you will often have huge amounts of data in your spreadsheets. In such a situation finding certain text in this huge ...

COUNTIF From Another Sheet in Google Sheets

It is more than likely that a workbook or spreadsheet may have multiple worksheets with various data organized and spread across it. It is also ...

COUNTIF Multiple Criteria in Google Sheets (3 Ways)

A veteran in Excel will tell you how powerful the COUNTIF function and all its iterations are. The same importance is carried over to Google Sheets. ...

Count Duplicates In Google Sheets (3 Ways)

When working with spreadsheets there will come a time when you will need to count duplicates in your data, whether it be for extraction or removal. ...

Highlight Duplicates in Google Sheets (4 Ways)

The ability to highlight duplicates in any worksheet is crucial for a variety of reasons. While it may sound easy to do, it can prove to be very ...

Change Row Color Based on Cell Value in Google Sheets (4 Ways)

Any type of formatting based on cell values or conditions can be easily done by the Conditional Formatting option of Google Sheets. To show you ...

OfficeWheel
Logo