View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Gord Dibben Gord Dibben is offline
external usenet poster
 
Posts: 22,906
Default 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.