Freeze panes grayed out

Under view in excel the freeze panes is grayed out, how do I activate it to
work with frozen columns and rows in a worksheet? I just recently loaded
Windows 2007 and it is so different than the prior excel that I was using
that it is taking me some time to figure it out. HELP??

Hi Btsult
I don't know if you are aware of these help attachment to make your life
less frustrating , if not have a look at these site
Keyboard shortcut
http://office.microsoft.com/en-us/ex...738481033.aspx
Look here for a cross reference for Excel 2003 - 2007
http://www.microsoft.com/downloads/d...displaylang=en
Same site you will find all sort of help for MS Office 2007.
BTW "Freeze panes is grayed out" if you're in Edit mode (F2)
HTH
Keep Smiling, life is too short
Regards
John

"Btsult" wrote in message
...
Under view in excel the freeze panes is grayed out, how do I activate it to
work with frozen columns and rows in a worksheet? I just recently loaded
Windows 2007 and it is so different than the prior excel that I was using
that it is taking me some time to figure it out. HELP??

Have you split the screen? If so, you can't freeze the panes also.
--
Daryl S


"Btsult" wrote:

Under view in excel the freeze panes is grayed out, how do I activate it to
work with frozen columns and rows in a worksheet? I just recently loaded
Windows 2007 and it is so different than the prior excel that I was using
that it is taking me some time to figure it out. HELP??

Is the workbook protected for Windows and Structure?

That will make freeze panes unavailable.


Gord Dibben MS Excel MVP

On Thu, 12 Nov 2009 08:18:02 -0800, Btsult
wrote:

Under view in excel the freeze panes is grayed out, how do I activate it to
work with frozen columns and rows in a worksheet? I just recently loaded
Windows 2007 and it is so different than the prior excel that I was using
that it is taking me some time to figure it out. HELP??