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
- In Google Sheets, open the spreadsheet where you want to create a filter view.
- Click a cell that has data.
- Select Data > Filter views > Create new filter view.
- 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.
- (Optional) To search for data, enter text in the search box.
- After you select the data to filter, click OK.
- Repeat steps 4–6 for each column you need to filter.
- 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.