How to use filter views in Google Sheets
Instead of a normal filter, use Data > Filter views > Create new filter view. Your filters stay in that named view and do not rearrange everyone else's screen.
Turn off by closing the dark filter-view bar or Data > Filter views > None.
Filter views are the right tool on shared sheets. Regular filters can confuse coworkers because they change the shared view.
Create a filter view
- Open the spreadsheet.
- Data > Filter views > Create new filter view.
- Use the column dropdowns to filter or sort.
- Click the name in the dark bar to rename the view (e.g. My open tasks).
- Close the view when finished; reopen anytime from Data > Filter views.
Filter view vs filter
Filter affects the sheet for everyone (while active). Filter view is personal/named and safer for collaboration.
Share a view link
While a filter view is open, copy the URL - it can open that view directly for others who have access.
Frequently asked questions
Why can't I create a filter view?
You need view access at minimum; some views require edit depending on protections.
Sort inside a filter view?
Yes - column menus support sort A-Z without changing other users' view.
Limit?
Large sheets can feel slower with complex views - keep ranges reasonable.