Home |
Search |
Today's Posts |
|
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
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. |
#2
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
You can apply a filter, then save it as a custom view.
To create a custom view, choose ViewCustom 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 Beatriz wrote: 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 Contextures http://www.contextures.com/tiptech.html |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
How to Filter cells and save the file with certain criteria? | New Users to Excel | |||
Refresh advanced filter | Excel Discussion (Misc queries) | |||
Save as problem with Save In drop down box | Excel Discussion (Misc queries) | |||
cannot edit and save | Excel Discussion (Misc queries) | |||
cannot edit and save | Excel Discussion (Misc queries) |