Create a personal filter view in Google Sheets
This is the procedure for saving sorting and filtering conditions without changing the display of co-editors. We will explain in detail the starting position, setting values, completion confirmation, and how to review in case of problems.
Published · Updated · FaultNote editorial policy
Who this guide is for and what to prepare
- First-time users of Google Sheets
- People who want to test creating a personal filter view in Google Sheets safely
What you need
- Decide on a table that has a heading row and is not divided by blank rows, and the filtering conditions.
Check preparation and starting position
Decide on a table that has a heading row and is not divided by blank rows, and the filtering conditions.
Open and configure features
- Select a cell in the table and select [Data] > [Create Filter View]. Change the view name to "Incomplete Only" in the top left of the black bar.
- Select [Filter by value] from the filter in the status column and leave only "Incomplete". If necessary, add [Filter by condition] to the deadline column as well.
Complete and check results
- Close the view with the x in the top right. Refresh the page by going to Data > Change View > Incomplete Only and confirm that the normal view has not changed.
Fix the problem and exit safely
Regular Create Filter can affect what collaborators see. Use filtered views for your own confirmation.
- To share conditions, pass the URL that opens the filter view. The other party will need permission to view the original sheet.
Limitations and requirements
- Regular Create Filter can affect what collaborators see. Use filtered views for your own confirmation.
Frequently asked questions
What if you can't find the item you want in Google Sheets?
To share conditions, pass the URL that opens the filter view. The other party will need permission to view the original sheet.
What should I be especially careful about when creating a personal filter view in Google Sheets?
Regular Create Filter can affect what collaborators see. Use filtered views for your own confirmation.
Official sources and verification date
Sources checked: . Check the official sources below for changes to supported systems, plans and menus.