rjbinney
Active Member
- Joined
- Dec 20, 2010
- Messages
- 294
- Office Version
- 365
- Platform
- Windows
Dear Internet:
I have two tables that I need to reference simultaneously. They fit neatly side-by-side on my worksheet.
Table "B" is about 12 rows and I need to be able to see all 12 rows while working with this file.
Table "A" is several hundred rows and needs to be frequently filtered on multiple criteria.
Of course, if I put them side by side, I can't Freeze the rows, because when I filter anything on "A", all of "B" disappears. (I am rarely looking at more than 40 rows of data in "A", but it's still enough that if I stack them, there's still lots of scrolling.)
Anyone have a hack where I can put the tables side-by-side, freeze the top few rows on the left half, and leave the right half intact? I am doing New Window=>Arrange Vertical, which works but is a little inelegant. And a pain every time I need to go in and out of other files.
I have two tables that I need to reference simultaneously. They fit neatly side-by-side on my worksheet.
Table "B" is about 12 rows and I need to be able to see all 12 rows while working with this file.
Table "A" is several hundred rows and needs to be frequently filtered on multiple criteria.
Of course, if I put them side by side, I can't Freeze the rows, because when I filter anything on "A", all of "B" disappears. (I am rarely looking at more than 40 rows of data in "A", but it's still enough that if I stack them, there's still lots of scrolling.)
Anyone have a hack where I can put the tables side-by-side, freeze the top few rows on the left half, and leave the right half intact? I am doing New Window=>Arrange Vertical, which works but is a little inelegant. And a pain every time I need to go in and out of other files.