Home

Excel Freeze Panes

%3CLINGO-SUB%20id%3D%22lingo-sub-240992%22%20slang%3D%22en-US%22%3EExcel%20Freeze%20Panes%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-240992%22%20slang%3D%22en-US%22%3EMy%20%E2%80%9CFreeze%20Pane%E2%80%9D%20tab%20is%20greyed%20out.%20How%20do%20I%20access%20it%20to%20Freeze%20rows%3F%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-240992%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-317681%22%20slang%3D%22en-US%22%3ERe%3A%20Excel%20Freeze%20Panes%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-317681%22%20slang%3D%22en-US%22%3E%3CP%3EI%20cannot%20access%20freeze%20pane%20s%20it%20is%20grayed%20out.%26nbsp%3B%20I%20have%20office%20365.%26nbsp%3B%20I've%20tried%20everything%20to%20get%20it%20to%20work%20but%20nothing%20seems%20to%20help.%26nbsp%3B%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-241044%22%20slang%3D%22en-US%22%3ERe%3A%20Excel%20Freeze%20Panes%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-241044%22%20slang%3D%22en-US%22%3E%3CP%3EHi%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EIf%20the%20worksheet%20is%20in%20the%20Page%20Layout%20view%2C%20switch%20to%20the%20Normal%20view%20because%20the%20Freeze%20Panes%20is%20not%20compatible%20with%20Page%20Layout%20view.%3C%2FP%3E%3C%2FLINGO-BODY%3E
Darryl Pierce
Visitor
My “Freeze Pane” tab is greyed out. How do I access it to Freeze rows?
2 Replies

Hi,

 

If the worksheet is in the Page Layout view, switch to the Normal view because the Freeze Panes is not compatible with Page Layout view.

I cannot access freeze pane s it is grayed out.  I have office 365.  I've tried everything to get it to work but nothing seems to help.