Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Reverting all Autofiltered columns to "ALL"
Hi
I have a number of Excel worksheets with Autofilters on each column. Once you've extracted the informaiton you need, it's a pain having to go to each columna nd check that you've reverted to "ALL" in each column. Is there an easy way to achieve this, such as with one click to revert every column simultaneously? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Reverting all Autofiltered columns to "ALL"
Hi,
You can select the complete row, where the Autofilter command has been given and then on the Data menu, point to Filter, and then click AutoFilter. Challa Prabhu "bollard" wrote: Hi I have a number of Excel worksheets with Autofilters on each column. Once you've extracted the informaiton you need, it's a pain having to go to each columna nd check that you've reverted to "ALL" in each column. Is there an easy way to achieve this, such as with one click to revert every column simultaneously? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Reverting all autofilter columns to "ALL". | Excel Discussion (Misc queries) | |||
can i change "A" to "Name" in reference to columns | Excel Discussion (Misc queries) | |||
How do display a "+" or "-" sign when hiding columns? | Setting up and Configuration of Excel | |||
HELP on "left","right","find","len","substitute" functions | Excel Discussion (Misc queries) | |||
Count occurences of "1"/"0" (or"TRUE"/"FALSE") in a row w. conditions in the next | New Users to Excel |