Freeze Panes in Excel 2007 - Vista

[Jen]

I wish to freeze panes in excel 2007 however, the option is not highlighted
i.e. I click on it but nothing appears. Help!

 

[Jacob Skaria]

Try that from cell B2.
http://inpics.net/tutorials/excel2007/vis5.html

If this post helps click Yes

 

[Je]

Make sure you are in Normal View--Freeze panes doesn't work in Page Layout
View.

Jane

 

[weewillie]

excuse top posting

using office 2007 sp1 on vista business

On my version of excel, view/freeze panes generates 3 options
1 unfreeze panes
2 freeze top row
3 freeze 1st column

there is no option merely marked 'freeze panes'
hence I can't freeze both the row and the columns I want which I could
in all previous versions of excel



please advise

n Tue, 31 Mar 2009 21:27:01 -0700, Jacob Skaria

 

[Gordon]

excuse top posting

using office 2007 sp1 on vista business

On my version of excel, view/freeze panes generates 3 options
1 unfreeze panes

Then you already have frozen panes.

 

[weewillie]

Then you already have frozen panes.

I hate to tell you this but as my post clearly states that is not true
Would you like me to semd a screen dump as proof?

 

[Debra Dalgleish]

What happens when you click on Unfreeze Panes?

What options are in the list after you click on Unfreeze Panes?

 

[Gordon]

I hate to tell you this but as my post clearly states that is not true
Would you like me to semd a screen dump as proof?

The "UNfreeze panes" option ONLY appears when panes have been frozen.

 

[weewillie]

Ahha! Eureka, problem goes away and yes I can freeze both r&c
must be a minor glitch in excel

Many thanks