How To Add A Filter In Excel?

Select the range of data or click any cell inside the table

Go to the Data tab on the ribbon

Click Filter

Use the drop-down arrows in the column headers to choose your filter criteria

Select the values or conditions you want to display

Click OK to apply the filter

To remove the filter, click Filter again on the Data tab

Suggested for You

Trending Today