Beginners Question setting up spreadsheet

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

PappyJoe - 31 Jul 2006 02:33 GMT

Hello,

I have a spreadsheet and the top roll has information that I need to be
able to see when I scroll down. How do I set it up so when I scroll
down the top roll or top couple of roll remain in place.

Thanks
PappyJoe

Signature

PappyJoe

Reply to this Message

Steel Monkey - 31 Jul 2006 02:36 GMT

If the data you want visible is in row 1 then select row 2, go to the
window menu, then click on split, then go to window menu and click on
freeze pane.

Signature

Steel Monkey

Reply to this Message

PappyJoe - 31 Jul 2006 03:14 GMT

Thanks, I tried that but when I did rolls 4-7 disappeared and just the
opposite of what I wanted to happen, happened. The bottom part of my
spread sheet froze and the top part would scroll. I must be doing
something wrong.

PappyJoe

Signature

PappyJoe

Reply to this Message

Ragdyer - 31 Jul 2006 03:50 GMT

Click in A2 *or* A3 and then
<Window> <Freeze Panes>

Check out this old link:

http://tinyurl.com/2qdzt

Signature

HTH,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------

>
> Thanks, I tried that but when I did rolls 4-7 disappeared and just the
[quoted text clipped - 3 lines]
>
> PappyJoe

Reply to this Message

PappyJoe - 31 Jul 2006 04:03 GMT

I got it. Once I changed the View from page layout to normal it
worked.

Thanks

Signature

PappyJoe

Reply to this Message

Gord Dibben - 31 Jul 2006 04:33 GMT

Window>Freeze Panes is enough.

You don't need the Split.

Split and Freeze Panes are two separate functions.

Gord Dibben MS Excel MVP

>If the data you want visible is in row 1 then select row 2, go to the
>window menu, then click on split, then go to window menu and click on
>freeze pane.

Reply to this Message