Skip to main content
In Spreadsheet, use Filter to select a subset of data from a Table by conditions for further analysis and processing, while hiding data you do not currently need.

​
Basic Filter: Turn Filter on and off

  1. Select the Cell range you want to filter, then click Filter on the toolbar to turn on Filter.
  2. A Filter button appears in the upper-right corner of every Cell in the first row of the selected range. Click the Filter button to start filtering. If you click Filter without selecting a range in the previous step, the entire Worksheet is filtered by default, and the Filter button appears in every Cell of the Worksheet’s first row.
  3. Click Filter on the toolbar again to turn off Filter.
  4. You can only turn on Filter for one Cell range in a Worksheet at a time.

​
Basic Filter: Filter types

  1. Filter by value: To quickly filter a category of data, enter a keyword in the Search box. The filter results include all items that contain the keyword. You can also filter by selecting the unique values in the panel.
  2. Filter by condition: To filter data that meets specific criteria, set the corresponding Filter conditions.
  3. Filter by color: To filter Cells by background color or Font color, select Filter by color.
  4. Filter visible only to me: To make filter results synchronized or unsynchronized, select “Filter visible only to me” in the filter panel as needed.

​
Advanced Filter: Non-interfering filter views

If you need to filter independently without affecting other people’s view of the data, or if you have view-only Permissions on the Spreadsheet but still want to filter data, use Filter view to filter data.
  1. Select the Cell range you want to filter, then click the dropdown arrow next to Filter on the toolbar, and select Create filter view. (On Mac: click Filter > More, then click Create filter view to enter the filter view interface.)
  2. In the filter view interface, the filter results are not synchronized to the original Table. You can also perform the following actions:
    1. Rename the filter view for easy identification.
    2. Reselect or change the filter range.
  3. The filter functions in a filter view work the same as Basic Filter, but Sort is not yet supported.
Back to Spreadsheet