Click any cell that contains data.
Click the filter button.
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.
Click Clear to remove all of the checks
Select the data you want to display on the spreadsheet. Click OK.
The sheet will be filtered according to your data selection. A filter symbol appears in the filtered column's header cell.