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.

Google Sheets Quick Reference

FREE Quick Reference

Click to Download

Free to distribute with our compliments; we hope you will consider our paid training.