How to create new filter view in Google Spreadsheet?
In google docs spreadsheet, there is an advanced option available to view the spreadsheet in a "Filter View" mode. Normally, if we add filter option, it can be viewed and edited by all other users to whom we given access, which will be interrupting our process. This can be avoided using "Filter View" option.
Option 1: Click Data → Filter Views → Create new filter view.
Option 2: Select Filter icon and choose "Create new filter view".
Step 2: Current spreadsheet file can be viewed in the Filter mode as given in the below image,
Step 3: Now, select the values to filter all other data based on the selection.
All the actions you performed in this filter view will be viewed only by you and not by your followers.