Filtering only certain columns

Closed
Ram - Feb 18, 2010 at 01:02 PM
rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 - Feb 18, 2010 at 01:09 PM
Hello,

I have to tables side by side in excel and I have autofilters at the top of each table(headers). When I filter by column in one table. It hides all the rows of that table which do not satisfy the condition. The problem is it also hides corresponding row in the other table (as it belongs to same row) and filtering done on entire row.

Now I want to hide/collapse/filter row cells only corresponds to first table. It should not change other table.

Thanks in advance
Rama

1 response

rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 766
Feb 18, 2010 at 01:09 PM
I dont think it is possible. Filter hides the row and not the cells
0