Using filter views in the new Google Sheets
Posted by Pamela Kistler-Osborne on 24 October 2014 02:06 PM

In Google Sheets, filtering your data makes it easier for you to view and analyze data by letting you hide data that you want to temporarily take out of view. The new Google Sheets introduces filter views as well, which allow you to create, name, and save filters that you can use without disrupting how others are viewing your spreadsheet.

Creating a filter view

When you create a filter view, it’s like saving a filter that you can use over and over again.

  1. Open the spreadsheet where you would like to create a filter view.
  2. Click the Data menu, hover over “Filter views…” and select Create a new filter view. You can also click the down arrow to the right of the filter  icon and select Create a new filter view.
  3. Using the down arrows in the column headers, sort and filter the data to fit your desired view. Your filter view will be saved as you make changes.
  4. To close your new filter view, either click the X in the top-right corner of the spreadsheet or click the down arrow to the right of the filter  icon and select None.


To delete or duplicate a filter view, click the gear icon in the top right corner of the filter view and choose Delete orDuplicate.
PKO 10/14
(63 vote(s))
Not helpful

Comments (0)
Post a new comment
Full Name: