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

L

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

Anon

Lisa said:
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?
Click to expand...

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