Freeze panes

Mar 7th, 2002, 11:18 AM

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 · Mar 7th, 2002, 11:26 AM

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.

Mar 7th, 2002, 11:32 AM

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 · Mar 7th, 2002, 11:43 AM

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

Mar 7th, 2002, 11:43 AM	#4
gplhl Board Regular Join Date: Feb 2002 Location: Chippenham, UK Posts: 136	If you want to repeat certain rows at the top goto Page Setup > Sheet __________________ Regards, Gary Hewitt-Long

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Mar 7th, 2002, 11:18 AM	#1
Guest Posts: n/a	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

Mar 7th, 2002, 11:26 AM	#2
Dave Gibson New Member Join Date: Feb 2002 Posts: 6	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.

Mar 7th, 2002, 11:32 AM	#3
Guest Posts: n/a	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