Excel: find Window in which I can freeze panes

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

4most - 08 Jul 2006 20:12 GMT

I cannot find the Window in the toolbar on which I can freeze panes, i.e.,
freeze column heads to prevent their scrolling out of view.

Reply to this Message

Roger Govier - 08 Jul 2006 22:15 GMT

Hi

Try
Windows>Freeze Panes

Signature

Regards

Roger Govier

>I cannot find the Window in the toolbar on which I can freeze panes,
>i.e.,
> freeze column heads to prevent their scrolling out of view.

Reply to this Message

George Gee - 08 Jul 2006 22:17 GMT

If you want to freeze row 1
Click cell A2, then on the keyboard press Alt + w, then f.

George Gee

>I cannot find the Window in the toolbar on which I can freeze panes, i.e.,
> freeze column heads to prevent their scrolling out of view.

Reply to this Message

Gord Dibben - 08 Jul 2006 22:55 GMT

If you are missing the "Window" drop-down menu from the Worksheet Menubar go to
Tools>Customize>Toolbars.

Select Worksheet Menu Bar and "Reset".

Gord Dibben MS Excel MVP

>I cannot find the Window in the toolbar on which I can freeze panes, i.e.,
>freeze column heads to prevent their scrolling out of view.

Reply to this Message