Description


If you're looking at a spreadsheet with other people, create a filter view that only you can see.

Examples

  • Working with collaborators on the same spreadsheet? Because filter views are turned on by each person viewing a spreadsheet, use a filter view to filter data without changing how others see the spreadsheet.
  • Share different filter view links with different people, so each person sees the most relevant information.
  • Save and name multiple filter views for quick access and sorting later.
  • Make a copy or create another view with similar rules.
  • Don’t have edit access to a spreadsheet and still want to filter or sort? Create a temporary filter view.


Instructions


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) To search for data, enter text in the search box.
  6. After you select the data to filter, click OK.
  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.