Select the data range or click any cell inside the table
Go to the Data tab
Click Filter
Click the drop-down arrow in the column header
Choose the values, text, numbers, or dates you want to show
Click OK
To clear a filter, click the drop-down arrow and select Clear Filter
To remove all filters, go to the Data tab and click Filter again
