Go to the “Data” menu and select Filter. You can also go to the toolbar and click the filter icon .

To see filtering options, click the down arrow to the right of the filter .

Filter by condition: Choose from a list of conditions or write your own. For example, if the cell is empty, if data is less than a certain number, or if the text contains a certain letter or phrase.

Filter by value: Uncheck any data points that you want to hide and click OK. If you want to choose all data points, click Select all. You can also uncheck all data points, by clicking Clear.

Search: Search for data points by typing in the search box. For example, typing "P" will shorten your list to just the names that start with P.

To turn the filter off, go to the “Data” menu and select Turn off filter. You can also click the filter icon.

Note: Only one filter is allowed per spreadsheet so that people don’t overwrite each other’s data. If you want more than one filter on a sheet, use filter views.
When you turn off and delete the filter, you’ll see all of your data but anything you’ve sorted will stay sorted.