excel should let me unfilter all columns with one click

[Guest]

Don't you hate it when you need to copy and paste, or even create a new
filtered search but you've got a bunch of active filters on already and you
have to scroll thru all your columns, unfiltering them one by one till it
reads "ready" again?

----------------
This post is a suggestion for Microsoft, and Microsoft responds to the
suggestions with the most votes. To vote for this suggestion, click the "I
Agree" button in the message pane. If you do not see the button, follow this
link to open the suggestion in the Microsoft Web-based Newsreader and then
click "I Agree" in the message pane.

http://www.microsoft.com/office/com...b1e9dff&dg=microsoft.public.excel.programming

 

[Norman Jones]

Hi B,

Have you tried:

Data | Filter Show All

 

[Roger Govier]

Hi

Right Click on your Toolbar area, and choose Customise>Commands>Data and
whilst holding your left mouse button down, drag Show All to any
position on one of your Toolbars.

Now a single click on this new button will remove all filters for you.

 

[Guest]

you

have to scroll thru all your columns, unfiltering them one by one till it
reads "ready" again?

Thanks for the laugh <g>