How to Use Filters in Google Sheets: A Step-by-Step Guide

Hey there! Are you tired of scrolling through rows and rows of data in Google Sheets just to find a specific piece of information? Well, I have some good news for you – filters can save you time and make your life so much easier! In this step-by-step guide, I'll walk you through exactly how to use filters in Google Sheets. Let's get started!

Step 1: Open Your Spreadsheet

The first thing you need to do is open your Google Sheet. If you don't have one yet, go ahead and create one by clicking on "Blank" or "From a template" on the Google Sheets homepage.

Step 2: Select the Data Range

Next, you'll want to select the range of data you want to filter. Click and drag your mouse across the cells to select the entire range. You can always adjust the range later if needed.

Step 3: Click on "Data" and Select "Create a Filter"

Now that you have your data range selected, click on the "Data" tab in the top toolbar and select "Create a Filter". You should see a small arrow appear in the header cell of each column.

Step 4: Filter Your Data

This is where the magic happens! Click on the arrow in the header cell of the column you want to filter by. You'll see a drop-down menu with several filtering options, including:

  • Sort A to Z or Z to A
  • Filter by condition (e.g. greater than, less than, text contains, etc.)
  • Filter by values (you can select specific values to include or exclude)

Select the filtering option that fits your needs and you'll see your data range automatically adjust based on your selection.

Step 5: Customize Your Filters

Filters are highly customizable in Google Sheets. You can add multiple filters to a single data range, adjust filter settings, and even save filters for future use.

To add an additional filter, simply click on the arrow in another header cell and select another filtering option. You can also adjust filter settings by clicking on the filter arrow and selecting "Filter settings".

And if you want to save a filter for future use, just click on the "Filter views" button in the top toolbar and select "Save as filter view". Give your filter a name and any time you open your sheet, you can easily apply your saved filter with one click.

Step 6: Turn Off Filters

Once you're done filtering your data, you may want to turn off the filters to see the full data range again. Simply click on the "Data" tab in the top toolbar and select "Turn off filter".


And that's it! Now you know how to use filters in Google Sheets like a pro. It may take a little practice to get the hang of it, but once you do, you'll wonder how you ever managed without them.

Happy filtering!

By clicking “Accept”, you agree to the storing of cookies on your device to enhance site navigation, analyze site usage, and assist in our marketing efforts. View our Privacy Policy for more information.