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?
|