Excel - freeze pane for more than one row anyone???

Asked By Angela on 22-Sep-07 11:50 PM
Can anyone tell me how to freeze more than one rows in version 2007? It
allows only a single row on the top or a single rom and column top and left,
respectively. I want to freeze the top 6 rows... This was possible in
previous Excel version but not in this one.

HELP please!
--
Angela




OssieMa replied on 23-Sep-07 03:24 AM
Hi Angela,

Click on the cell below where you want to freeze the panes and on the View
Ribbon
click the dropdown beside freeze panes and select the first option (Freeze
Panes).

Regards,

OssieMac
Angela replied on 23-Sep-07 11:26 AM
Thanks OssieMac, it endedup working after several tries... for some reason
the option under "freeze panes" was not working for about 5 tries. I had to
restart the program. It is working now.

I have another question for you. In 2007 version I cannot find the "about
Microsoft" info under "help." When I wanted to chat with Microsoft they asked
for my product number and I tried everythign in my power toget to find it.

Where is the product number for the 2007 version?

The info they give about how to find it does not work for the 2007 version
on my computer (click on the MS Office icon --double click opens it, right
click does not give the options they want, and under "help" inthe open
programs I don't find "about" anywhere).

Thanks!
--
Angela
David Phypers replied to Angela on 17-Nov-10 12:14 PM
Go to row 7, then click Freeze frames
Pete_UK replied to David Phypers on 17-Nov-10 02:02 PM
I hope they have not been waiting 3+ years for your solution !!

Pete
Clif McIrvin replied to Pete_UK on 17-Nov-10 02:15 PM
I hope they have not been waiting 3+ years for your solution !!

Pete



Don't you just love the off-the-wall stuff that is coming through from
Egghead Cafe these days?!!

--
Clif McIrvin

(clare reads his mail with moe, nomail feeds the bit bucket :-)
Jim Cone replied to Clif McIrvin on 18-Nov-10 05:52 PM
Clif,
I took a short look at the Egghead website a while back.
There was a short blurb to the effect that you could get paid for answering questions.
Conclusions...
--
Jim Cone
Portland, Oregon  USA

.
.
.

I hope they have not been waiting 3+ years for your solution !!

Pete



Don't you just love the off-the-wall stuff that is coming through from
Egghead Cafe these days?!!

--
Clif McIrvin

(clare reads his mail with moe, nomail feeds the bit bucket :-)
Clif McIrvin replied to Jim Cone on 18-Nov-10 07:01 PM
Yeah, I saw that.  I also noticed that Egghead Cafe is deriving income
from click-through advertising .... sigh.

Clif




--
Clif McIrvin

(clare reads his mail with moe, nomail feeds the bit bucket :-)