Excel freeze pane not working

%3CLINGO-SUB%20id%3D%22lingo-sub-2348571%22%20slang%3D%22en-US%22%3EExcel%20freeze%20pane%20not%20working%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2348571%22%20slang%3D%22en-US%22%3E%3CP%3EHello%2C%20I%20am%20working%20with%20Office%20365.%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20was%20working%20on%20a%20sheet%20and%20trying%20to%20freeze%20the%20left%20three%20columns.%20However%2C%20once%20selecting%20and%20going%20to%20freeze%2C%20the%20table%20froze%20the%20top%2012%20rows%20and%20also%20added%20a%20grid%20to%20the%20table.%20Can%20someone%20offer%20advice%20on%20how%20to%20reformat%20freeze%20or%20why%20this%20is%20happening%3F%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2348571%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EExcel%20for%20web%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EOffice%20365%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
Occasional Visitor

Hello, I am working with Office 365. 

 

I was working on a sheet and trying to freeze the left three columns. However, once selecting and going to freeze, the table froze the top 12 rows and also added a grid to the table. Can someone offer advice on how to reformat freeze or why this is happening? 

 

1 Reply

@aemazz 

First, select Freeze Panes > Unfreeze Panes.

Then select the entire column D.

Finally, select Freeze Panes > Freeze Panes.