I have an excel spreadsheet with about 400 rows. I have a quick-review table with a bunch of countif
cells that update based on the data in the rows. The table is in columns K-O
while the actual data is on columns A-H
.
I want to review this review data (which goes from rows 2 to 18) while working further down in the document. I can split horizontally, but then I need my top 18 rows to be dedicated to the review table. That's a little wasteful. I can split vertically, but I only get one scroll-bar, so I can't look down further in my spreadsheet.
Is there a way I can vertically split where one can be on row 2ish and the other view can be on row 200ish? If I can't, is there some other way I can have a quick view of this data?
So far, the only way I've managed to do it is by spawning a new window, and re-sizing them. This seems a little more cumbersome than I'd prefer, and I'm still looking for a better way to do it!