Google Sheets / Google Sheets Power User
Use filter views
If you filter your sheet as described above, everyone that views the sheet will see the same filter when they open it. If you want collaborators to be able to view data differently when they open the sheet, you can use filter views.
You can create multiple filter views in a sheet, giving each a name that can be selected to view that set of data at any time.
Creating a filter view
To create a new filter view:
Click anywhere in the range of data you wish to filter
Click on the drop-down arrow of the Filter button on the toolbar
Choose Create new filter view
Use the drop-down arrows next to each heading to choose the values you wish to display, and the order you wish to sort that column by
Set a name for the filter view by clicking on the Name: along the top of the view and typing a new name. Press Enter to name the view
To return to showing all data in the sheet, click on the Close button along the top of the filter view
Saving a filter as a filter view
If you have used the standard filter command to apply a filter to your spreadsheet, you can save it as a filter view as follows:
Click on the drop-down arrow of the Filter button on the toolbar
Choose Save as filter view
Set a name for the filter view by clicking on the Name: along the top of the view and typing a new name. Press Enter to name the view.
Showing a filter view
To show a filter view, click on the drop-down arrow of the Filter button on the toolbar and choose the name of the filter you wish to view.
To delete or duplicate a filter view, click on the Options cog along the top of the view.