Filter a Spreadsheet in Google Sheets

Click any cell that contains data.

Click the filter button.

Google spreadsheet filter1

A drop-down arrow appears in each column header.

Decide which column you will apply a filter to. Click the column's dropdown arrow and a filtering options box appears. You will see the values from that column as a checklist inside the box.

Google spreadsheet filter2

Click Clear to remove all of the checks

Select the data you want to display on the spreadsheet. Click OK.

Google spreadsheet filter3

The sheet will be filtered according to your data selection. A filter symbol appears in the filtered column's header cell.

Google spreadsheet filter4