Select B2 and on the View tab, click Freeze Panes, and the top choice, Freeze
Panes - the description is keep rows and columns visible while the rest of
the worksheet scrolls (based on current selection). It works the same as the
old Freeze Panes command did and freezes everything to the left and above the
current selection.

"Jon M" wrote:

How do you freeze top row and 1st column in excel 2007 at the same time. The
current options seem to be either one or the other.

Thanks!