How to filter your Google Sheets without affecting other users?
Filter data without changing what collaborators see
Click a cell that has data. 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.