| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Select ALL filter in one fell swoop
Sometimes it is difficult to see all the columns which has a filter
applied, is there a convenient way to select the ALL option on a filter for all the filters in the sheet. I do not want to remove the filter only have a handy way of not having the filter applied. there could be up to 6 columns filtered on the sheet at the same time. |
|
#2
|
|||
|
|||
|
Choose DataFilterShow All
Pat wrote: Sometimes it is difficult to see all the columns which has a filter applied, is there a convenient way to select the ALL option on a filter for all the filters in the sheet. I do not want to remove the filter only have a handy way of not having the filter applied. there could be up to 6 columns filtered on the sheet at the same time. -- Debra Dalgleish Excel FAQ, Tips & Book List http://www.contextures.com/tiptech.html |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Macro for Filter Switches ... Maybe??? | Excel Discussion (Misc queries) | |||
| Filter Switches vs Macro? | Excel Discussion (Misc queries) | |||
| Dynamic Formulas with Dynamic Ranges | Excel Worksheet Functions | |||
| advanced filter won't allow me to filter on bracketed text (-456.2 | Excel Discussion (Misc queries) | |||
| Select or Filter by Fill Color | Excel Worksheet Functions | |||
Linear Mode
