Split screens

[Tammyg]

I have a large wookbook with multiple column groups. I want to split these
column groups & be able to scroll up & down within the group and all the
other column groups not move. When I split the column, it only shows the
scroll bar at the bottom to scroll left or right. Is there a way to be able
to scroll up & down within the column group? I will also need muliple splits
& I can't seem to get that either.

 

[Luke M]

Fro what you're wanting to accomplish, and for the amount of splits required,
it would probably be easier to create new windows as opposed to splits.

With your workbook open within a session of XL, go to Window, New Window.
Repeat this step for as many "splits" as you wanted. Now go to Window,
Arrange, (pick your preference). You now have multiple views of the same
workbook, that you can individually adjust.