Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
DiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWord
DirectoryUser Groups
Related Topics
Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ...

MS Office Forum / Excel / General Excel Questions / May 2007

Tip: Looking for answers? Try searching our database.

Freezing panes in Excel 2007?

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Jon M - 19 May 2007 14:28 GMT
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

 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.