Select the data range or click anywhere inside the table
Go to the Data tab
Click Filter
Use the drop-down arrows in the header row
Choose the values you want to show
Use Text Filters, Number Filters, or Date Filters for specific conditions
Click OK to apply the filter
Clear filters by opening the drop-down and selecting Clear Filter From
Turn off filtering by clicking Filter again on the Data tab