Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
autofilters on worksheets within workbook
i'm using Excel 2007. I have about 12 worksheets within a workbook.
I want to know how I can clear the filters on all worksheets and return each worksheet to showing all records without going through each worksheet individually and clearing the filter. ie. can I click or do something just once that will clear the filters in all worksheets, or do I have to go to each s/sheet and clear the filter??? if this can only be done as a programming code, as i'm not really that smart, can you please tell me where I have to put this code. -- thanks Cheryl |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Combine worksheets in multiple workbook in one workbook with a macro | Excel Discussion (Misc queries) | |||
Shared workbook and autofilters | Excel Discussion (Misc queries) | |||
AutoFilters | Excel Worksheet Functions | |||
How to set up AutoFilters? | Excel Worksheet Functions | |||
autofilters | Excel Worksheet Functions |