save filter

[Guest]

Does excell allow you to save a "custom" auto filter? Every morning I have to
monitor a spreadsheet with diferent kind of decisions work order. For
example:
WO# Decision
1 Approved
2 Denied
3 Approved
4 In Process
etc
I have several kind of decisions that I have to monitor every day, so I go
to Data/Filter/Auto Filter and then custom my filter because I have different
kind of approves and different kind of denied, etc.
Is there a way that I can SAVE my custom filters? Then I can just click on
my save filter instead of custom it over and over again.

 

[Debra Dalgleish]

You can apply a filter, then save it as a custom view.
To create a custom view, choose View>Custom Views
Click Add
Type a name for the view, and check the box to include hidden rows,
columns and filter settings
Click OK

To view a saved custom view, choose View Custom Views
Select a view, and click Show