Making rows fixed so when you scroll down you still see top rows.

[Lisa]

I need to "fix" the top three rows of a spreadsheet so
that when you scroll down the sheet, the top 3 rows don't
move. Can anyone help?

 

[AndyB]

Lisa

Select cell a4 and then Window>Freeze Panes

Andy.

 

[Anon]

I need to "fix" the top three rows of a spreadsheet so
that when you scroll down the sheet, the top 3 rows don't
move. Can anyone help?

Select cell A4 and use
Window > Freeze Panes

You can freeze columns at the left too. The selected cell is the first one
from the top left that you want to scroll. So, to freeze 4 rows and 2
columns, you would select C5.