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!
BoniM - 19 May 2007 15:16 GMT
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.
> 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!
Bernard Liengme - 19 May 2007 15:17 GMT
Move to cell B2; on the View tab click the down arrow on Freeze Panes icon;
select the first item - to freeze both row & column
Best wishes

Signature
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email
> 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!
Dave Peterson - 19 May 2007 15:21 GMT
Show A1 (to make sure column A and row 1 are visible)
then select B2
Then apply the freeze panes.
You'll be freezing all the rows above that active cell and you'll be freezing
all the columns to the left of that activecell.
> 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!

Signature
Dave Peterson