Beginners Question setting up spreadsheet

[PappyJoe]

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

[Steel Monkey]

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.

[PappyJoe]

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

[PappyJoe]

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

Thanks

[Gord Dibben]

Window>Freeze Panes is enough.

You don't need the Split.

Split and Freeze Panes are two separate functions.


Gord Dibben MS Excel MVP

On Sun, 30 Jul 2006 21:36:33 -0400, Steel Monkey
<[email protected]> wrote:

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