| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Reverting all autofilter columns to "ALL".
Hi
We have a number of Excel spreadsheets with Autofilters on all columns. Once you've slected the information you want, it's a total pain to have to go through every coulmn reverting each Autofilter to "ALL". Is there an easy way to make all columns revert to "ALL" after you'ved used the feature? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Reverting all autofilter columns to "ALL".
Try
Data - Filter - Show all Does that help? Mike "bollard" wrote: Hi We have a number of Excel spreadsheets with Autofilters on all columns. Once you've slected the information you want, it's a total pain to have to go through every coulmn reverting each Autofilter to "ALL". Is there an easy way to make all columns revert to "ALL" after you'ved used the feature? |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Reverting all autofilter columns to "ALL".
Duh, thanks Mike. Now I feel really stupid!
I can see I'll have to find far more complex problems next time! "Mike" wrote: Try Data - Filter - Show all Does that help? Mike "bollard" wrote: Hi We have a number of Excel spreadsheets with Autofilters on all columns. Once you've slected the information you want, it's a total pain to have to go through every coulmn reverting each Autofilter to "ALL". Is there an easy way to make all columns revert to "ALL" after you'ved used the feature? |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Reverting all autofilter 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 We have a number of Excel spreadsheets with Autofilters on all columns. Once you've slected the information you want, it's a total pain to have to go through every coulmn reverting each Autofilter to "ALL". Is there an easy way to make all columns revert to "ALL" after you'ved used the feature? |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Reverting all autofilter columns to "ALL".
You can add an icon to your favorite toolbar (xl2003 and below):
Tools|Customize|Commands tab|Data category Drag the "show all" button to your favorite toolbar (and the autofilter button, too???). bollard wrote: Hi We have a number of Excel spreadsheets with Autofilters on all columns. Once you've slected the information you want, it's a total pain to have to go through every coulmn reverting each Autofilter to "ALL". Is there an easy way to make all columns revert to "ALL" after you'ved used the feature? -- Dave Peterson |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| 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 | |||
| How do I get rid of "Top 10" and "Custom" choices Autofilter? | Excel Worksheet Functions | |||
Linear Mode
