Google Sheets Filter Views

In Google sheets, one option for viewing a subset of data  is to use Filter views (Data > Filter views). This is the simplest way to make a reusable filtered/sorted view of your data.

In effect it sits on top of your data set and any sort or filter you apply does not affect what others will see in the source data. The colour scheme around the sheet changes to indicate you are in filter view.

Filters views can also be named and saved, and will be accessible to others with whom the file is shared. Any viewer can set up a filter view, but you need edit permissions to save it.

YouTube and film icon
Example Filter views are included in the data functions sample file (see Data > Filer Views...).
There's a video clip below that shows how they work:
Filter View example

An example of Google Sheets Filter View