#1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 1
Default save filter

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   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 2,979
Default save filter

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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
How to Filter cells and save the file with certain criteria? DanJanowiak New Users to Excel 6 March 29th 06 11:55 PM
Refresh advanced filter Dan Excel Discussion (Misc queries) 1 March 25th 06 01:33 AM
Save as problem with Save In drop down box Doug Excel Discussion (Misc queries) 3 March 16th 06 02:46 PM
cannot edit and save jp Excel Discussion (Misc queries) 1 February 8th 05 05:12 PM
cannot edit and save jp Excel Discussion (Misc queries) 0 February 8th 05 03:27 AM


All times are GMT +1. The time now is 06:07 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"