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%3CLINGO-SUB%20id%3D%22lingo-sub-2689445%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-2689445%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%20%26nbsp%3BThank%20you%20so%20much.%26nbsp%3B%20I%20never%20comment%20on%20here%20but%20I%20registered%20so%20that%20I%20could%20thank%20you%20for%20such%20an%20easy%20solution%20to%20such%20an%20annoying%20problem%20that%20I%20have%20struggled%20with%20and%20tolerated%20for%20years.%26nbsp%3B%20Once%20again%20I%20on%20a%20whim%20decided%20to%20ask%20Google%20World%20for%20an%20answer%20and%20there%20you%20were%20with%20an%20solution.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ECurious%2C%20did%20you%20discover%20this%20one%20on%20your%20own%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2689502%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-2689502%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1138761%22%20target%3D%22_blank%22%3E%40HDD-Portland_Realtor%3C%2FA%3E%26nbsp%3BYou're%20welcome.%20Glad%20I%20could%20help%20resolve%20a%20problem.%20Can't%20really%20remember%20when%20I%20%22discovered%20this%22.%20I've%20been%20using%20Excel%20since%20it%20first%20came%20out.%20So%2C%20I%20guess%20it%20came%20%22naturally%22.%20Never%20really%20thought%20about%20it%2C%20actually.%3C%2FP%3E%3CP%3E%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

6 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... 

@Riny_van_Eekelen  Thank you so much.  I never comment on here but I registered so that I could thank you for such an easy solution to such an annoying problem that I have struggled with and tolerated for years.  Once again I on a whim decided to ask Google World for an answer and there you were with an solution.

 

Curious, did you discover this one on your own?

@HDD-Portland_Realtor You're welcome. Glad I could help resolve a problem. Can't really remember when I "discovered this". I've been using Excel since it first came out. So, I guess it came "naturally". Never really thought about it, actually.