One Button click to "unfilter"

[bradjedis]

Hey all,

I have a spreadsheet where I have several filters set (using the typical methods). From time to time, I need to clear all of the filters.

Assume header row to be row 5, data columns in use: C thru K data beginning in row 6.
I would like to have this as a macro so that I can assign a button to do the task.


Any help is always greatly appreciated.


Thanks,
Brad

[HansV]

The line

ActiveSheet.ShowAllData

will cancel all filtering on the active sheet. You can include this line in a macro.

[bradjedis]

cool.

Thanks,
Brad

[kathon]

For anyone who doesn't want a macro to do this, the Data-Filter-Show All command can be moved (via customize) from the sub menu to the toolbars for a one-click 'unfilter all' operation.

[HansV]

Welcome to Eileen's Lounge!

For those using Excel 2007 or later: the equivalent is the "Clear" button. You can customize the Quick Access Toolbar, select "Home Tab" in the "Choose commands from" dropdown, select Clear and add it to the Quick Access Toolbar.

x307.png