Scroll two columns on right while left is stationary

W

widman

I hava a spreadsheet where users are to fill in from a3 to k44. One of the
things they need is the account code that is in O3 to Q67.

I've been trying different things with split and freeze, but haven't figured
out how to let the input side stay put (or scroll down slightly depending on
screen resolucion) while the right hand side is scrolable.

Is this possible?
 
G

Gord Dibben

Select L1 and Window>Freeze Panes.

Alternative is Window>New Window>Arrange>Vertical.

You can now re-size the two to have A to K in left side and O to Q in right
side.


Gord Dibben Excel MVP
 
D

David McRitchie

I don't think SPLIT would help you, it is mutually exclusive to FREEZE panes,
and would not help you see column A:K and Q at the same time.

I think you would want to hide columns, you can record a macro
and I think use it as recorded.

Select columns L:p, Format, columns, Hide
to unhide columns, Select K:Q, Format, columns, Unhide
 
Top