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

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

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