Google Sheets Filter

How to Filter Data in Google Sheets

Google Sheets Training

Google Sheets Training Features:

  • Interactive bite-sized lessons

  • Get Certified

  • Accurate skill assessments

  • Customizable, LMS-ready content

Prices
Users love us
4.9 stars out of 5 on G2

4.9 out of 5 on G2

Google Sheets Filter

By filtering data, you can view only the information that's important. This is really helpful when you're working in huge spreadsheets.

Filter Data

  1. Select a cell within a data range.
  2. Click Data on the menu bar.
  3. Select Create a filter.
    Filter Data

    A filter button is added to each column header.

  4. Click the filter arrow for a column.
  5. Specify the items you want to filter.
  6. Click OK.
    Filter Data

The data within the range is filtered based on the criteria you selected.

Advanced Filters

You can also set up advanced filters that filter data by specific conditions. For example, you can filter data so that only values that are greater than a certain amount will appear.

  1. Click the filter arrow for a column.
  2. Click Filter by condition.
  3. Click the condition list arrow.
  4. Select a condition.
    Filter Data
  5. Set that condition's value.
  6. Click OK.
    Filter Data

The data is filtered and only shows the values that meet the conditions you specified.

Clear a Filter

If you no longer need the filter, clear it to see all of the data again.

  1. Click Data on the menu bar.
  2. Select Turn off filter.
    Filter Data

The filter is removed, and you can see all the cells in the data range again.