SOLVED

How to freeze Rows & columns at the same time

%3CLINGO-SUB%20id%3D%22lingo-sub-2070441%22%20slang%3D%22en-US%22%3EHow%20to%20freeze%20Rows%20%26amp%3B%20columns%20at%20the%20same%20time%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2070441%22%20slang%3D%22en-US%22%3E%3CP%3EI%20have%20Excel%20365%20for%20Mac.%20I%20need%20to%20freeze%20my%20Column%20A%20and%20Rows%201-3%20at%20the%20same%20time.%20Excel%20Help%20says%20I%20can%20do%20this%20via%20View%20%26gt%3B%20Freeze%20Panes%20but%20in%20View%20I%20see%20no%20such%20option%2C%20only%20Unfreeze%20Panes%2C%20Freeze%20Top%20Row%20and%20Freeze%20First%20Column.%3C%2FP%3E%3CP%3E(It%20used%20to%20be%20easy%20in%20Excel%20fro%20Mac%202016!)%3C%2FP%3E%3CP%3ETHANKS%20EVERYBODY%20-%20and%20Happy%20New%20Year%20despite%20everything.%3C%2FP%3E%3CP%3ECN%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2070441%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2070478%22%20slang%3D%22en-US%22%3ERe%3A%20How%20to%20freeze%20Rows%20%26amp%3B%20columns%20at%20the%20same%20time%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2070478%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F933012%22%20target%3D%22_blank%22%3E%40Charlie_Nairn%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EApparently%2C%20Freeze%20Panes%20is%20already%20active.%3C%2FP%3E%0A%3CP%3ESo%20first%20select%20Unfreeze%20Panes%20from%20the%20Freeze%20Panes%20dropdown.%3C%2FP%3E%0A%3CP%3EThen%20select%20cell%20B4%2C%20and%20select%20Freeze%20Panes%20from%20the%20Freeze%20Panes%20dropdown.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2071787%22%20slang%3D%22en-US%22%3ERe%3A%20How%20to%20freeze%20Rows%20%26amp%3B%20columns%20at%20the%20same%20time%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2071787%22%20slang%3D%22en-US%22%3E%3CP%3EThanks%20Hans%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F127945%22%20target%3D%22_blank%22%3E%40Hans%20Vogelaar%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3EYour%20faultless%20advice%20worked%20perfectly.%3C%2FP%3E%3CP%3EExcel%20help%20is%20surprisingly%20unclear%20and%20suggests%20freezing%20column%20A%20first%20-%20which%20of%20course%20freezes%20that%20column%20and%20then%20you%20can't%20freeze%20rows.%3C%2FP%3E%3CP%3EBut%20you've%20explained%20%3CU%3Ehow%20to%20freeze%20Excel%20Rows%20%26amp%3B%20Columns%20at%20the%20same%20time%3C%2FU%3E%20101%25%20clearly%20%26amp%3B%20accurately.%3C%2FP%3E%3CP%3ESo%20...%20THANK%20YOU%20again.%3C%2FP%3E%3CP%3Ecn%3C%2FP%3E%3C%2FLINGO-BODY%3E
New Contributor

I have Excel 365 for Mac. I need to freeze my Column A and Rows 1-3 at the same time. Excel Help says I can do this via View > Freeze Panes but in View I see no such option, only Unfreeze Panes, Freeze Top Row and Freeze First Column.

(It used to be easy in Excel fro Mac 2016!)

THANKS EVERYBODY - and Happy New Year despite everything.

CN

3 Replies
best response confirmed by Charlie_Nairn (New Contributor)
Solution

@Charlie_Nairn 

Apparently, Freeze Panes is already active.

So first select Unfreeze Panes from the Freeze Panes dropdown.

Then select cell B4, and select Freeze Panes from the Freeze Panes dropdown.

Thanks Hans @Hans Vogelaar 

Your faultless advice worked perfectly.

Excel help is surprisingly unclear and suggests freezing column A first - which of course freezes that column and then you can't freeze rows.

But you've explained how to freeze Excel Rows & Columns at the same time 101% clearly & accurately.

So ... THANK YOU again.

cn

It works. Thanks for your great advice.

It's so simple but can be frustrating if you don't know how!

@Hans Vogelaar