Basics

Google Sheets: Filter Data that Contains Text (3 Easy Ways)

Filtering in a spreadsheet is a common task. But it is good to understand that there are a lot of ways and scenarios where filters can be applied. ...

Google Sheets: Filter for Multiple Criteria with Formula (2 Easy Ways)

Conditional filtering is a staple in many spreadsheet processes. But what if you wanted to filter for multiple conditions? Thankfully, we have a ...

How to Fill Down an Entire Column in Google Sheets (4 Easy Ways)

Inputting data in a spreadsheet one by one can be long and tedious. Thankfully, applications like Google Sheets provide its users with multiple ways ...

Google Sheets Smart Fill: Recognize and Autocomplete Patterns (A Complete Guide)

If you’ve been following recent updates, you will know about the new AI-powered addition to Google Sheets, the Smart Fill. In this article, we ...

Google Sheets: How to Autofill Based on Another Field (4 Easy Ways)

The term Autofill can take many forms in Google Sheets, of which the most common is the fill-down columns method in a worksheet. On the other hand, ...

Filter Data Using Filter Views in Google Sheets (An Easy Guide)

The Filter Views of Google Sheets is an amazing functionality that allows users to collaborate and filter data without affecting the source data. ...

Google Sheets: Filter Data if it Contains Value (A Comprehensive Guide)

Google Sheets has improved in functionality by quite a bit over the years. We now have not only one but two different ways we can filter data if it ...

How to Filter Custom Formula in Google Sheets (3 Easy Examples)

Sometimes the available filter options of the spreadsheet just do not cut it. While there are many, the user may require a customized approach to ...

Google Sheets Autofill: Fill Cells Automatically (A Comprehensive Guide)

Over the years, Google Sheets has continued to add much-needed features with every update, especially those catered toward making data presentation ...

How to Set a Filter in Google Sheets (An Easy Guide)

When working with large sets of data, you may want to arrange the data in such a way that it matches the criteria that you are looking for. That’s ...

How to Delete Filter Views in Google Sheets (An Easy Guide)

With Google constantly updating its applications, it can be quite difficult to keep track of the new features that may now be included. One of which ...

How to Create Filter Views in Google Sheets (An Easy Guide)

Filtering data is a core function of any spreadsheet. Unfortunately, when you have a lot of collaborators, there's a high likelihood of unwanted ...

How to Autofill Numbers in Google Sheets (An Easy Guide)

In this simple guide, we will show you how to autofill numbers in Google Sheets by taking advantage of the application’s automated understanding of ...

How to Autofill Formula in Google Sheets (3 Easy Ways)

The autofill option is a much-desired feature for any user of office applications. Not only is it convenient, but it is also a time-saver to go ...

How to Use a Custom Formula in a Google Sheets Slicer (An Easy Guide)

Since slicers are essentially a type of filter, there can arise situations where the user might need to customize the filter conditions to suit their ...

OfficeWheel
Logo