freeze column and row on same spread sheet

[linda]

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

 

[Gord Dibben]

Select B2 and Freeze Panes.

Column A and Row 1 will remain frozen.


Gord Dibben MS Excel MVP

 

[Carl_B]

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