freeze pane horizontal and vertical?

**11ktran44** · 08-14-2010, 09:37 PM

Hello all:

Is there a way to freeze title fields horizontally and some collumns in the same sheet? I have tried but it only work one way. Perhaps, autofill can do the work, but I am just curious if it is possible.

Regards,
KT

**JBeaucaire** · 08-14-2010, 10:03 PM

You can select ANY cell on the sheet and freeze panes at that point. Any rows above that cell will remain visible and any columns to the left of that cell will remain visible.

Keep in mind the integrity of columns will be preserved. So if you put your cursor in C3 and freeze, the columns A:B will always be visible and the rows 1:2 will always be visible, but the only cells that CAN'T scroll off the screen are A1:B2.

**11ktran44** · 08-24-2010, 10:55 PM

Thanks so much J. Beaucaire.

Originally Posted by JBeaucaire

You can select ANY cell on the sheet and freeze panes at that point. Any rows above that cell will remain visible and any columns to the left of that cell will remain visible.

Keep in mind the integrity of columns will be preserved. So if you put your cursor in C3 and freeze, the columns A:B will always be visible and the rows 1:2 will always be visible, but the only cells that CAN'T scroll of the screen are A1:B2.