View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Debra Dalgleish Debra Dalgleish is offline
external usenet poster
 
Posts: 2,979
Default How can I use AutoFilter without supressing rows ?

No, you can't apply an AutoFilter to one table without affecting another
table in the same rows on that sheet.
Perhaps you could put the second table on a different sheet. If you need
to see the tables side by side, open another window in the workbook, and
arrange the windows vertically.

Alexandre wrote:
Ive got 2 tables in Excel 2007 which are arranged in parallel. Is it
possible to create a filter that works just for one table, with no side
effects to the other one? Currently when one is filtered, the other one is
being supressed (filtered) as well. I wish Ive made myself clear and hope
you could help me on this. Thank you.



--
Debra Dalgleish
Contextures
http://www.contextures.com/tiptech.html