How can I use AutoFilter without supressing rows ?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I’ve 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 I’ve made myself clear and hope
you could help me on this. Thank you.
 
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.
 
Back
Top