Freeze panes

[Guest]

Hello
I am trying to do the freeze panes to lock the first 2 rows. But it always freeze the wrong rows. So I am wondering what should I select or where should I place my cursor before I select Freeze Panes?
Also, if someone print the sheet can they also see those freezed rows?
Thanks

 

[Dave Gibson]

The panes freeze at the top and left of the cell the cursor is currently in. If you want to lock the first two rows of a spreadsheet, you need to put your cursor in cell A3. The pane function has no effect on printing.

 

[Guest]

I am just wondering what should I do if I want to print a portion of the spreadsheet as well as the rows that have been frozen?
Thanks

 

[gplhl]

If you want to repeat certain rows at the top goto Page Setup > Sheet