Scroll two columns on right while left is stationary
 

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?

Select L1 and WindowFreeze Panes.

Alternative is WindowNew WindowArrangeVertical.

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

On Wed, 28 Sep 2005 06:33:04 -0700, widman
wrote:

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?

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

---
HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm

"widman" wrote in message ...
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?