If your worksheet has a lot of data, finding specific information can be hard. Filters help by showing only the data you need.

Download our Practice Workbook.

Steps to Filter Data

  1. Prepare Your Worksheet
    • Make sure your worksheet has a header row. This row should have labels for each column.
    • Example: Your worksheet might have columns like ID#, Type, and Equipment Detail.

  2. Apply a Filter

    • Click on the Data tab.
    • Click the Filter button.
    • Small drop-down arrows will appear in the header row.

  3. Filter a Column

    • Click the drop-down arrow in the column you want to filter.

    • Uncheck Select All to remove all selections.

    • Check the boxes for the data you want to see.

    • Click OK.
    • Now, only the selected data is visible. Other data is hidden.

Applying Multiple Filters

You can filter more than one column.

  • First, apply a filter to one column.
  • Then, apply another filter to a different column.

Example:

  • Filter Type to show only laptops and projectors.
  • Then, filter Date to show only items checked out in August.

To remove a filter:

  • Click the drop-down arrow in the filtered column.

  • Select Clear Filter From [Column Name].

  • The hidden data will appear again.

To remove all filters:

  • Click the Filter button on the Data tab again.

Advanced Filtering Options

  1. Search Filtering
    • Click the drop-down arrow in a column.

    • Type a word or number in the search box.

    • Only matching data will be shown.

  2. Text Filters
    • Click the drop-down arrow and hover over Text Filters.

    • Choose an option like "Does Not Contain".

    • Enter the word you want to exclude.

    • Click OK.

  3. Number Filters
    • Click the drop-down arrow and hover over Number Filters.
    • Select an option like "Between".

    • Enter a number range (e.g., 3000 to 6000).

    • Click OK.

  4. Date Filters
    • Click the drop-down arrow and hover over Date Filters.

    • Choose a time period like "Between".

    • Enter the date range (e.g., July 15 to August 15).

    • Click OK.