Select the data range or click anywhere inside the table
Go to the Data tab
Click Filter
Click the drop-down arrow in the column header
Select the values you want to show
Use Text Filters, Number Filters, or Date Filters for specific conditions
Click OK to apply the filter
Clear or remove filters from the column drop-down when needed
Turn off filtering by clicking Filter again on the Data tab