Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
excel should let me unfilter all columns with one click
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/comm...el.programming |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
excel should let me unfilter all columns with one click
Hi B,
Have you tried: Data | Filter Show All --- Regards, Norman "B" wrote in message ... 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/comm...el.programming |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
excel should let me unfilter all columns with one click
Hi
Right Click on your Toolbar area, and choose CustomiseCommandsData 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. -- Regards Roger Govier "B" wrote in message ... 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/comm...el.programming |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
unfilter | Excel Discussion (Misc queries) | |||
cannot RIGHT click on rows or columns in excel | Excel Discussion (Misc queries) | |||
Code to unfilter one field only | Excel Programming | |||
Columns in Excel will not allow user to click in them | Excel Discussion (Misc queries) | |||
Unfilter | Excel Programming |