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:  How to merge multiple Excel files into one file

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

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

Text data type

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

TOP TUTORIALS:  [yii2] How to refresh a captcha with a button or reload a page

* : 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