LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 58
Default Document filter conditions that are in effect

I have a big spreadsheet where each column is filtered. I select what I want
to view or print by selecting filter conditions, sometimes custom conditions.

I'd like to be able to see easily what filter conditions are in effect,
without clicking on each column individually. Similarly, I'd like to display
the filter conditions in the spreadsheet itself, so that when I print it, the
printout will document what rows are being selected.

Is there any way to do this? I'm using Excel 2003.

Thanks.


 
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
Text Effect A.Mourice[_2_] Excel Discussion (Misc queries) 1 November 4th 08 02:09 PM
Excel 2003 Advanced filter does not effect data list Jojon Excel Discussion (Misc queries) 1 September 5th 08 12:47 PM
What is the reverse effect? Rebecca Excel Discussion (Misc queries) 1 March 14th 06 03:21 PM
Summary Counts Functions to filter multiple conditions Kamlesh Excel Worksheet Functions 2 March 14th 06 10:51 AM
How do I filter with multiple conditions in one field? TJ Excel Discussion (Misc queries) 4 September 28th 05 11:16 PM


All times are GMT +1. The time now is 11:35 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"