Freeze panes not working properly

%3CLINGO-SUB%20id%3D%22lingo-sub-1218044%22%20slang%3D%22en-US%22%3EFreeze%20panes%20not%20working%20properly%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1218044%22%20slang%3D%22en-US%22%3E%3CP%3EI'm%20having%20an%20issue%20with%20freeze%20panes.%20I'm%20trying%20to%20freeze%20the%20first%202%20columns%20and%20the%20top%20row%20of%20a%20large%20worksheet%2C%20so%20I'm%20using%20%22Freeze%20top%20row%22%20for%20the%20top%20row%2C%20and%20selecting%20the%203rd%20column%20and%20selecting%20%22Freeze%20panes.%22%20The%20row%20and%20columns%20stay%20frozen%20for%20a%20while%2C%20but%20the%20freeze%20panes%20command%20%22wears%20off%22%2C%20and%20sometimes%20doesn't%20work%20at%20all.%20I'm%20using%20Excel%202016%2C%20and%20I've%20never%20had%20this%20problem%20before.%20TIA.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1218044%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1218065%22%20slang%3D%22en-US%22%3ERe%3A%20Freeze%20panes%20not%20working%20properly%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1218065%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F577640%22%20target%3D%22_blank%22%3E%40ACDeBellis%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3EMake%20sure%20the%20active%20cell%20is%20C2%20then%20select%20Freeze%20Panes.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EFreeze%20top%20row%20%3D%20Free%20top%20%3CSTRONG%3Evisible%3C%2FSTRONG%3E%20row%3C%2FP%3E%3CP%3EFreeze%20first%20column%20%3D%20Freeze%20first%20%3CSTRONG%3Evisible%3C%2FSTRONG%3E%20column%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1218114%22%20slang%3D%22en-US%22%3ERe%3A%20Freeze%20panes%20not%20working%20properly%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1218114%22%20slang%3D%22en-US%22%3EHello%2C%20%3CBR%20%2F%3EUsually%20in%20this%20case%2C%20you%20will%20probably%20have%20headings%20in%20i.e%20row%203.%20If%20your%20headings%20is%20in%20row%203%20and%20you%20want%20to%20Freeze%20row%203%20and%20the%20first%202%20columns%20(A%20and%20B)%2C%20you%20need%20to%20select%20cell%20C4.%20Then%2C%20apply%20Freeze%20Panes.%3CBR%20%2F%3E%3CBR%20%2F%3EThis%20will%20Freeze%20the%20first%20two%20columns%20and%20the%20first%203%20rows.%20When%20you%20scroll%20to%20the%20right%20and%20down%2C%20you%20will%20notice%20the%20freezing%3C%2FLINGO-BODY%3E
Highlighted
Occasional Visitor

I'm having an issue with freeze panes. I'm trying to freeze the first 2 columns and the top row of a large worksheet, so I'm using "Freeze top row" for the top row, and selecting the 3rd column and selecting "Freeze panes." The row and columns stay frozen for a while, but the freeze panes command "wears off", and sometimes doesn't work at all. I'm using Excel 2016, and I've never had this problem before. TIA.

2 Replies
Highlighted

@ACDeBellis 

Make sure the active cell is C2 then select Freeze Panes.

 

Freeze top row = Free top visible row

Freeze first column = Freeze first visible column

Highlighted
Hello,
Usually in this case, you will probably have headings in i.e row 3. If your headings is in row 3 and you want to Freeze row 3 and the first 2 columns (A and B), you need to select cell C4. Then, apply Freeze Panes.

This will Freeze the first two columns and the first 3 rows. When you scroll to the right and down, you will notice the freezing