freeze panes, freezes more than I select

%3CLINGO-SUB%20id%3D%22lingo-sub-1179400%22%20slang%3D%22en-US%22%3Efreeze%20panes%2C%20freezes%20more%20than%20I%20select%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1179400%22%20slang%3D%22en-US%22%3E%3CP%3EI'm%20trying%20to%20freeze%20the%20first%20two%20rows%20in%20a%20spreadsheet%2C%20however%20when%20I%20select%20them%20then%20click%20freeze%20panes%20it%20ends%20up%20freezing%20the%20first%2010%20rows%20not%20just%20the%20two%20I%20selected.%20Does%20anyone%20have%20any%20suggestions%3F%3C%2FP%3E%3CP%3ETIA%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1179400%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1179437%22%20slang%3D%22en-US%22%3ERe%3A%20freeze%20panes%2C%20freezes%20more%20than%20I%20select%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1179437%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F561926%22%20target%3D%22_blank%22%3E%40jhaynie%3C%2FA%3E%26nbsp%3BYou%20don't%20have%20to%20select%20rows.%20Just%20select%20the%20cell%20directly%20below%20and%20to%20the%20right%20of%20where%20you%20want%20to%20freeze%20the%20rows%2Fcolumns.%20In%20your%20case%2C%20select%20C1%20and%20then%20%22Freeze%20panes%22.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1946098%22%20slang%3D%22en-US%22%3ERe%3A%20freeze%20panes%2C%20freezes%20more%20than%20I%20select%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1946098%22%20slang%3D%22en-US%22%3EThanks!%20Not%20intuitive%2C%20but%20that%20did%20the%20trick!%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2054861%22%20slang%3D%22en-US%22%3ERe%3A%20freeze%20panes%2C%20freezes%20more%20than%20I%20select%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2054861%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F403176%22%20target%3D%22_blank%22%3E%40Riny_van_Eekelen%3C%2FA%3E%26nbsp%3BThank%20you.%20really%20simple%20solution%20for%20such%20an%20irritating%20problem.%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2114619%22%20slang%3D%22en-US%22%3ERe%3A%20freeze%20panes%2C%20freezes%20more%20than%20I%20select%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2114619%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F403176%22%20target%3D%22_blank%22%3E%40Riny_van_Eekelen%3C%2FA%3E%26nbsp%3BThanks%20for%20that%20hint!%20I've%20struggled%20with%20this%20for%20years.%20Best%20hidden%20feature%20ever...%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E
Occasional Visitor

I'm trying to freeze the first two rows in a spreadsheet, however when I select them then click freeze panes it ends up freezing the first 10 rows not just the two I selected. Does anyone have any suggestions?

TIA

4 Replies

@jhaynie You don't have to select rows. Just select the cell directly below and to the right of where you want to freeze the rows/columns. In your case, select C1 and then "Freeze panes".

Thanks! Not intuitive, but that did the trick!

@Riny_van_Eekelen Thank you. really simple solution for such an irritating problem. 

@Riny_van_Eekelen Thanks for that hint! I've struggled with this for years. Best hidden feature ever...