If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Why is there no Freeze Panes option in the Windows drop-down box?
My colleague has no Freeze Panes in his Windows drop-down box. He has
forwarded the same spreadsheet to me, and I do have the Freeze Panes option when I open the document. (Excel 2003 SP3 on Windows XP). Thx. |
#2
|
|||
|
|||
Why is there no Freeze Panes option in the Windows drop-down box?
Your colleague may have modified his toolbar (maybe by accident, too).
He can reset that toolbar via: Tools|Customize|Toolbars tab Select Worksheet Menu Bar and click Reset Any other customized changes to that toolbar will need to be redone, though. PortNatal wrote: My colleague has no Freeze Panes in his Windows drop-down box. He has forwarded the same spreadsheet to me, and I do have the Freeze Panes option when I open the document. (Excel 2003 SP3 on Windows XP). Thx. -- Dave Peterson |
#3
|
|||
|
|||
Why is there no Freeze Panes option in the Windows drop-down box?
No entry at all or just grayed out?
If no entry at all...........ToolsCustomizeToolbars Scroll down to Worksheet MenuBar and "reset" Note: this will destroy any customizations of that Toolbar and reset to default. Alternate route. ToolsCustomizeCommandsTools Drag "Freeze Panes" up to Window dropdown box. Gord Dibben MS Excel MVP On Mon, 22 Jun 2009 11:19:01 -0700, PortNatal wrote: My colleague has no Freeze Panes in his Windows drop-down box. He has forwarded the same spreadsheet to me, and I do have the Freeze Panes option when I open the document. (Excel 2003 SP3 on Windows XP). Thx. |
Thread Tools | |
Display Modes | |
|
|