Excel: Vertical Split with separate vertical scrolls?

[KnickNut3]

Here's what I want to do--can I do it?

I want to have a vertical split of a tab. I want to be able to control the vertical position of each half separately. For example, I'd like to keep a long list on the right side of the tab that I keep scrolling on, while having the left side (which is full of conditional totals, etc.) stay and not scroll.

I used to have these conditional totals at the top using a frozen pane, but the list has gotten too extensive, and I'd like to keep it on the side.

I know I can somewhat accomplish this using "new window" and centering both accordingly, but I have a lot of other tabs I use (without a split) and would prefer to find a way to set it up this way permanently so I don't have to reconfigure it every time I switch back to this tab.

Thanks for your help!

 

[IHateMyJob2004]

by tab you mean worksheet?

Seems like you already know how to split a worksheet. To my knowledge you can not make them scrollable independently like you request. Open Office?

 

[KnickNut3]

Yes, worksheet. You seem to be right... not sure why they can't do this, though.

 

[dullard]

I am a bit confused as to why you can't just freeze pane with the totals on the side instead of the top. But, if you don't want to just move them to the side and do a vertical freeze pane, then what about a vertical view split? In 2007, simply click the View tab, and select Split (it is in the Window subtab). Then, move the horizontal split off the screen and adjust the vertical split as necesary. There you go, both sides are scrollable within a single worksheet.

I don't have 2003 or older in front of me, so I can't give you directions for those versions.

 

[Snapster]

Originally posted by: dullard
I am a bit confused as to why you can't just freeze pane with the totals on the side instead of the top. But, if you don't want to just move them to the side and do a vertical freeze pane, then what about a vertical view split? In 2007, simply click the View tab, and select Split (it is in the Window subtab). Then, move the horizontal split off the screen and adjust the vertical split as necesary. There you go, both sides are scrollable within a single worksheet.

I don't have 2003 or older in front of me, so I can't give you directions for those versions.

It doesn't work because the vertical scroll is locked with each pane meaning there is only one scrollbar on the right. The only way I can think of atm is a side by side spreadsheet view, ie create a copy of your workbook and open the copy next to original so you can compare data.

 

[KnickNut3]

Yes snapster, you can do this without opening it again using "New Window" which gives you two views of the same workbook that when you change one, the other changes.

Problem is then when I switch to another worksheet I have to remaximize the one sheet, and it's cumbersome.