PDA

View Full Version : [SOLVED] Rows Repeat at Top



Jane
05-12-2005, 11:11 AM
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
05-12-2005, 12:19 PM
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