View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Eric_NY Eric_NY is offline
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.