Rows Repeat at Top

[Jane]

Hello,

Would anyone let me know how to make the first four rows ($1:$4) show at the top of the spreadsheet attached.

Thanks!

[mvidas]

Hi Jane,

If you want the full rows to remain at the top, select cell A5, go to Window, then Freeze Panes.

The freeze panes option will 'lock' every row above it and every column to the left of it on the screen. Since you want the 4 rows, we choose the first column and the 5th row. If you wanted rows 1:3 at the top and column A on the left always visible, you would go to B4 and choose Freeze Panes.

Matt