Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Apply all autofilters
Is there a way of re-applying all the autofilters in a workbook? I've got
several autofilters on different worksheets, and it will be useful to be able to apply all the filters at once, rather than going through each worksheet and doing it manually. (Excel 2003) |
#2
|
|||
|
|||
Malcomio,
You could record a macro as you apply the autofilters. Be sure to start the recorder before you select the first sheet, or the macro will start in the sheet you happen to be in when it's run. -- Earl Kiosterud www.smokeylake.com "malcomio" wrote in message ... Is there a way of re-applying all the autofilters in a workbook? I've got several autofilters on different worksheets, and it will be useful to be able to apply all the filters at once, rather than going through each worksheet and doing it manually. (Excel 2003) |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to apply the same background to many sheets simultaneously. | Excel Worksheet Functions | |||
make custom header and footer in excel apply to all worksheets | Excel Discussion (Misc queries) | |||
I would like to apply the same calculation to an entire row | Excel Worksheet Functions | |||
Is there a way to apply "page setup" defaults to an existing work. | Excel Discussion (Misc queries) | |||
count & Autofilters | Excel Worksheet Functions |