Working with remote and in-office colleagues? Learn how to thrive in hybrid work environments.

Filter data in a spreadsheet



If you're looking at a spreadsheet with other people, create a filter view that only changes your view of the data.


  • 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.

Filter data without changing what collaborators see""

  1. In Google Sheets, open the spreadsheet where you want to create a filter view.
  2. Click a cell that has data.
  3. Select Dataand thenFilter viewsand thenCreate 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 Dataand thenFilter views. Filter views have dark gray highlights in the column and row headers.

Filter data for everyone""

  1. Select a range of cells.
  2. Click Dataand thenCreate a filter.
  3. Go to the top of the range and click Filter Filter to see the filter options.
Was this helpful?
How can we improve it?
Clear search
Close search
Google apps
Main menu
Search Help Center