How to Filter in Excel

How to Filter Data in Excel

Excel Training

Excel Training Features:

  • Interactive bite-sized lessons

  • Get Certified

  • Accurate skill assessments

  • Customizable, LMS-ready content

Prices
Users love us
4.9 stars out of 5 on G2

4.9 out of 5 on G2

How to Filter in Excel

When you create a table, a filter button that looks like a list arrow is added to the header of each column in the table. You can use this arrow to filter the table columns; they remain available when you scroll down the list. You can filter by values such as text, numbers, or dates.

Filter

  1. Click the filter arrow for the column you want to filter.

    A list appears, displaying several options for sorting or filtering the table data. A check box will appear for each of the unique data entries for the selected field.

  2. Select the check box(es) of the filter criteria you want to use.

    You can also click in the Search field and type the criteria by which you want to filter, or click Text Filters to apply advanced filtering criteria.

  3. Click OK.
    Filter Data

Clear a Filter

  1. Click the filter arrow for the column with a filter you want to clear.
  2. Select Clear Filter From “Column Name.”
    Filter Data

    You can also click the Filter button on the Data tab to toggle the filter off.

The filter is removed and all the data in that column is visible again.