Fixed cells?

T

TimM

Hello i'm trying to firuge out how to make like 3 or 4 cells at the top of my
sheet stay on screen when scroling down the sheet. Also if it's even possible
the make 2 or 3 stay on the bottom of the screen as well. I'm just not sure
how to tackle this even though i see it used often in my work place.
 
K

KL

Hi,

For the first one - select the cell, say [A4], go to menu Window>Freeze
Panes. You can also freeze columns or both in the same way depending on
which cell you choose to select.

For the second one - use menu Window>Split

Regards,
KL
 
T

TimM

Ok that works great the only part is that when I try to use both one just
over rides the other. I guess i could just put that information on the top
but then it looks funny, and is just that bigger of a hasell.

Thanks very much for your quick response by the way.
--
Thanks
TimM


KL said:
Hi,

For the first one - select the cell, say [A4], go to menu Window>Freeze
Panes. You can also freeze columns or both in the same way depending on
which cell you choose to select.

For the second one - use menu Window>Split

Regards,
KL
Click to expand...
 
D

Dave Peterson

Not quite the same...

Maybe you could use:
Window|new window
then Window|Arrange|horizontal

Then you could have two windows showing the same worksheet. Then you could show
anything you want in either window (independent of each other).
 
Top