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""

Important: When you add a filter, anyone with access to your spreadsheet will see the filter too. Anyone with permission to edit your spreadsheet will be able to change the filter.
  1. On your computer, open a spreadsheet in Google Sheets.
  2. Select a range of cells.
  3. Click Data and then Create a filter.
  4. To see filter options, go to the top of the range and click Filter Filter.
    • Filter by condition: Choose conditions or write your own.
    • Filter by values: To hide data points, uncheck the box next to the data point and click OK.
    • Search: Search for data points by typing in the search box. 
    • Filter by color: Choose which text or fill color to filter by. You can filter by conditional formatting colors, but not alternating colors.
  5. To turn the filter off, click Data and then Remove filter.
Was this helpful?
How can we improve it?
Clear search
Close search
Google apps
Main menu
Search Help Center