Select the data range you want to filter
Go to the Data tab
Click Filter
Use the drop-down arrows in the column headers
Choose the values or conditions you want to display
Click OK to apply the filter
Use Text Filters, Number Filters, or Date Filters for specific conditions
Clear the filter from the drop-down menu when needed
Turn off Filter by clicking Filter again on the Data tab