Using Filters in Excel

3 January 2022

Home » Blogs » Technology » Using Filters in Excel

Excel has a “Filter” feature to display data with certain criteria.

How to use filters in Excel

  1. Select the data to be filtered.
  2. Select “ Data > Filters ”.
excel filter 01
  1. In the header of the data table a dropdown button will appear to apply the criteria.
excel filter 02

You can apply several types of data criteria, such as date, text, and number.

TOP TUTORIALS:  Easy Ways to Change List Separator on Function in Excel

Date data type

To use this date filter, click the dropdown button in the header. Then select “Date Filters”. You will see a lot of filter options available, starting from Before, After, Today, This Month, and so on. You can also filter on a specific date by using the “Custom Filter”.

excel filter 03

uses the computer date as a reference. If you select “Today”, will filter according to the date you are currently using on the computer.

Text data type

In the text data type, you can use “” to filter. Wildcards you can use

TOP TUTORIALS:  Causes of Unable to Close or Quit Excel in Windows 11

* : represents multiple characters. For example, “sales* ”, will filter everything that starts with “sales”.

? : represents a single character. For example ” sa?es “, will filter the word “sa” + one letter of any character + “es”

excel filter 04

Data type Number

With this data type, you can filter by comparison. Such as Equal, Greater Than, Between, and so on. You also filter by comparing average data, such as Above Average and Below Average.

excel filter 05