How can I use AutoFilter without supressing rows ?

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.
 
D

Debra Dalgleish

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Update Excel table in Word automatically from data in Excel 1
Single Front End File with Form that Can by Filtered By User 7
VBA: How can I use a string variable as autofilter criteria? 4
How do I join a range of cells? 1
Conditional Autofilter For Formula 4
Filling in blank rows 1
How to populate a column in a row based on a value in another colu 3
Access 2003 pivot table subform 0

Top