Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Autofilter
I am using Excel97 as a database, when applying several autofilters to taste, is there a way to remember or automate the selections of the autofilters I have used, to apply to the list at a later date. I have ordered the Excel97 book from the library and awaiting it to be returned from a lender. Thanks |
#2
|
|||
|
|||
You can use Custom Views to store the settings:
Filter the table Choose ViewCustom Views Click the Add button Type a name for the custom view Make sure that 'hidden rows, columns and filter settings' has a check mark Click OK To show a saved custom view, choose ViewCustom Views Select a view, click Show Rodney wrote: I am using Excel97 as a database, when applying several autofilters to taste, is there a way to remember or automate the selections of the autofilters I have used, to apply to the list at a later date. I have ordered the Excel97 book from the library and awaiting it to be returned from a lender. Thanks -- Debra Dalgleish Excel FAQ, Tips & Book List http://www.contextures.com/tiptech.html |
#3
|
|||
|
|||
Thank you very much for your help, Debra. | You can use Custom Views to store the settings: | | Filter the table | Choose ViewCustom Views | Click the Add button | Type a name for the custom view | Make sure that 'hidden rows, columns and filter settings' has a check mark | Click OK | | To show a saved custom view, choose ViewCustom Views | Select a view, click Show -- | 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 | |||
Frozen panes in Excel should stay put when using autofilter. | Excel Discussion (Misc queries) | |||
how to write macro after autofilter is applied | Excel Worksheet Functions | |||
New Project, Different Problem: AutoFilter? | Excel Discussion (Misc queries) | |||
Can I AutoFilter an entire workbook? | Excel Discussion (Misc queries) | |||
Strange Results with Autofilter | Excel Discussion (Misc queries) |