Filter data in shared spreadsheets without changing what collaborators see

To create a filter view

  1. In Google Sheets, open the spreadsheet where you want to create a filter view.
  2. Click a cell that has data.
  3. Select Data > Filter views > Create new filter view.
  4. Click a drop-down list in a column header and select the data you want to filter. Your filter view is saved as you make changes.
  5. (Optional) Search for data by entering text in the search box.
  6. After you select the data to filter, click .
  7. Repeat steps 4–6 for each column you need to filter.
  8. In the Name box, enter a name for your filter view. If you don’t enter a name, the filter view is saved as Filter number, where number corresponds to the number of filters you’ve created.

Your saved filter view now appears in Data > Filter views. Filter views have dark gray highlights in the column and row headers.

Have more questions? Submit a request

Comments

Powered by Zendesk