Use filter views.

Filter views is a built-in feature that allow spreadsheet editors to set the range to be filtered, keep the filter settings between sessions and can be used by others, including viewers. To find the option, click the Help menú, then in the textbox type filter views.

Use filter views

Filter views is a built-in feature that allows spreadsheet editors to set the range to be filtered, keep the filter settings between sessions and can be used by others, including viewers. To find the option, click the Help menú, then in the textbox, type filter views.

Addendum

At this time, searching

• [google-sheets] "filter views" is:question returns 20 questions. The question with the largest number of views is Why are sheet Filter Views not updating for new rows?.
• [google-sheets] "filter views" is:answer returns 59 answers. The top answer, with a score of +39 is fotamus' answer to Multi user filter issue in Google Spreadsheets.