Prev: subtotal, match?
Next: Whats wrong with this array formula
From: linda linda on 16 Feb 2010 13:20
freeze column and row on same spread sheet - will only freeze one or the other
From: Gord Dibben on 16 Feb 2010 13:30
Select B2 and Freeze Panes.

Column A and Row 1 will remain frozen.


Gord Dibben MS Excel MVP

On Tue, 16 Feb 2010 10:20:01 -0800, linda <linda @discussions.microsoft.com>
wrote:

>freeze column and row on same spread sheet - will only freeze one or the other

From: Carl_B on 16 Feb 2010 14:01
This is somewhat version specific
Click one cell below the bottom row you want frozen and on column to the
right of the columns you want frozen.
In Excel 2003 and earlier, Window menu, Freeze Panes (that is from memory
for sure it is on the Window menu, actual command may have slightly different
name)
In Excel 2007, View tab, Window group, Freeze Panes


"linda" wrote:

> freeze column and row on same spread sheet - will only freeze one or the other
 | 
Pages: 1
Prev: subtotal, match?
Next: Whats wrong with this array formula