Microsoft Excel

Ron de Bruin
Excel Automation

Microsoft MVP Program

EasyFilter add-in for Excel

What Does EasyFilter Do?

Briefly! EasyFilter is a multi-optioned tool that allows far easier filtering of data. It allows easier manipulation of the results of the filtering. Once EasyFilter has been installed, all of the options are accessed by simply right clicking any cell within a criteria field in your data range. There is also a new menu item below the *EasyFilter* menu item that say *Clear Filters* to clear the filter. If you open *EasyFilter* it always clear the filter first so no need to always use *Clear Filter*. Important : Use Headers above your Data. Note: The add-in is not working in a Table, I got another add-in named Table Tools for Tables.

When was the first EasyFilter version created

I created EasyFilter for Excel 2000-2003 a long time ago and on Aug 2006 I have upload the last version to my website. It was a great project with help and suggestions from my Excel friends Norman Harker, Dave Peterson, Bob Philips and the late Frank Kabel who was tragically killed in an accident in his home country of Germany on 5th January 2005.

The new version for the new Excel versions

After 15 years it was time to update the add-in so it is also works in the last versions of Excel for Windows, there is a Mac version also now. When I was updating the add-in I not understand why I waited for so long because it is still a cool tool.


Filter Options are on separate tabbed User Interface and options available are:

Equal-Not Equal [Filters for up to five alternative = or <> criteria]
Blanks [Filters for Blanks or non Blanks or Formulas that evaluate to "" or not]
Greater-Less [Filters for >= OR > AND / OR <= OR <]
Begins-Contains-Ends [Ideal for filtering text fields]
Unique-Duplicate [At last an easy way to hunt out uniques and duplicates]
Special [Text searching with wild cards with up to 5 Or / And criteria]

Dates [Not enabled unless you are filtering a field containing dates]
Color [Fill/Font colors (Normal and Conditional Formatting colors) and Bold cells]

With exception of Unique-Duplicates, option tab, you have 7 "Where-Hows" available:

1) Filter in place
2) Copy to new worksheet
3) Copy to new workbook
4) Delete rows
5) Hide rows
6) Copy next to your data
7) Copy below your data

And for the “Unique-Duplicate” tabbed option only:

1) Filter in place
2) Copy to another location
3) Copy to new worksheet
4) Copy to new workbook
5) Unique or Duplicate

Download version 3.2

Download version 3.2 for Excel for Windows Date published 22-Oct-2021

Version 3.2 fixed a bug on non English systems and I changed the code for Date filtering.

Extract it to a unprotected local directory and then Click on File, click on Options, click the Add-ins tab. In the Manage drop-down, choose Excel Add-ins, and click Go. Use “Browse” to go to the add-in and then click on OK. Verify EasyFilter is checked in the add-in list and then click OK.

Note: If you not see the menu option to open EasyFilter in the Cell menu when you right click a cell in your data it is possible that Excel block the add-in. Follow the steps below one time to fix this.

1: Close Excel
2: right click the Add-in file
3: Choose properties
4: On the General tab Unblock it

Note: Please let me know if you have problems with the add-in or have suggestions

Note: If you are a Mac user see this page : EasyFilter | Mac Excel Automation


Many thanks to Norman Harker, Dave Peterson, Bill Manville, Bob Phillips and the late Frank Kabel for their help and suggestions.