Excel 2007 : Freeze Panes

[scott41]

Good Morning all,

I am having a minor annoyance with the attached sheet.

I wish to "freeze panes" in a way that keeps everything to the left of column "H" visible AND everything above row "6" visable at the same time, no matter where i scroll to on the sheet.

Hope one of you nice people can help

Scott

[teylyn]

Hi scott,

hit Freeze Panes on the view Ribbon and delete the current freeze settings with Unfreeze panes to clear the slate. Then select H6 and click Freeze Panes - Freeze Panes

hth

[scott41]

That does it. Thank you very much indeed

Scott