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

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

If this post helps click Yes
---------------
Jacob Skaria


"Jen" wrote:

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

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

Jane

"Jen" wrote:

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

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
wrote:

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

If this post helps click Yes
---------------
Jacob Skaria


"Jen" wrote:

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

wrote in message
...
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.

--
Asking a question?
Please tell us the version of the application you are asking about,
your OS, Service Pack level
and the FULL contents of any error message(s)

On Tue, 21 Apr 2009 18:12:36 +0100, "Gordon"
wrote:

wrote in message
.. .
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.

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?

What happens when you click on Unfreeze Panes?

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

wrote:
On Tue, 21 Apr 2009 18:12:36 +0100, "Gordon"
wrote:


wrote in message
. ..

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.


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
Contextures
www.contextures.com/tiptech.html
Blog: http://blog.contextures.com

wrote in message
...
On Tue, 21 Apr 2009 18:12:36 +0100, "Gordon"
wrote:

wrote in message
. ..
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.

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.

--
Asking a question?
Please tell us the version of the application you are asking about,
your OS, Service Pack level
and the FULL contents of any error message(s)

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

Many thanks


On Tue, 21 Apr 2009 19:53:34 -0400, Debra Dalgleish
wrote:

What happens when you click on Unfreeze Panes?

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

wrote:
On Tue, 21 Apr 2009 18:12:36 +0100, "Gordon"
wrote:


wrote in message
...

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.


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?