Freeze panes grayed out

[Btsult]

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??

 

[John]

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/excel/HP100738481033.aspx
Look here for a cross reference for Excel 2003 - 2007
http://www.microsoft.com/downloads/...BD-2758-47B3-9F90-93788112B985&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

 

[Daryl S]

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

 

[Gord Dibben]

Is the workbook protected for Windows and Structure?

That will make freeze panes unavailable.


Gord Dibben MS Excel MVP