Split Column but independent vertical scroll?

[always_confused]

Hello,

I have 2 lists that i'd like to be able to compare in my spreadsheet. One is quite short (20 rows), and one is quite long(75 000 rows). To do this, I would like to split the spreadsheet into two parts with independent vertical scrolling. I have seen that using .SplitColumn I get the correct splitting but the scrolling is independent horizontally and vice versa for .Split Row. Is there some other way to achieve this splitting with independent vertical scrolling.

Not really looking for other solutions to the problem that don't include the split screen, as I already have a solution I'm happy with (buttons that just send you to the correct spot in either list), but my boss insists on this split screen way of doing things.....
Thanks for your help.

 

[Zot]

I don't think it is possible. Split Horizontally only then can scroll vertical independently on single workbook and sheet.

You can do with two workbook though

 

[always_confused]

I don't think it is possible. Split Horizontally only then can scroll vertical independently on single workbook and sheet.

Ok thanks anyways

 

[Zot]

Ok thanks anyways

Just sab=ve the workbook as another name and open both, View side by side.

 

[Kellog]

Hello,

I have 2 lists that i'd like to be able to compare in my spreadsheet. One is quite short (20 rows), and one is quite long(75 000 rows). To do this, I would like to split the spreadsheet into two parts with independent vertical scrolling. I have seen that using .SplitColumn I get the correct splitting but the scrolling is independent horizontally and vice versa for .Split Row. Is there some other way to achieve this splitting with independent vertical scrolling.

Not really looking for other solutions to the problem that don't include the split screen, as I already have a solution I'm happy with (buttons that just send you to the correct spot in either list), but my boss insists on this split screen way of doing things.....
Thanks for your help.

I had the same question and after several searches it seems that this can't be done on a sheet. I ended up diving into Excel Forms. Although it can seem daunting to learn this, the ability to completely customize things in anyway you want, are so satisfying that its well worth the effort.

 

[awoohaw]

Can't you just open a new "Window" of the workbook?
From Main Menu Select "VIEW", in the Window Section, Click "New Window". Then you can resize the two copies of hte workbook as you see fit.

 

[Kellog]

Can't you just open a new "Window" of the workbook?
From Main Menu Select "VIEW", in the Window Section, Click "New Window". Then you can resize the two copies of hte workbook as you see fit.

Sure you can. But then you need to resize and rearrange windows each time (I do this several times a day). I was commenting that creating an Excel Form is a much more elegant way of handling things.