I know I can split at column F and each will scroll individually horizontally but I want them to independently scroll vertically. Is this possible?
Here is a fiddle of an example of what I want in HTML/css
Here is a screencap of my spreadsheet just so you guys can get an idea of why I'm trying to do this:
Ideally it wouldn't even have two scrollbars. The right few columns would just stick where they are (they would never need to be scrolled).
I don't believe this is a duplicate of this question for two reasons: First, his requirements are only to "freeze" the right-most column. I need multiple. Second, the accepted solution is the "split" option, which as I stated above only allows independent horizontal scrolling, not vertical as I require.
Best Answer
The only way I know is View -> New Window , and then Arrange All -> Vertical.
You will have two windows of the same worksheet so you can move horizontally and vertically on each window independently of the other window.