Excel Web App - freeze BOTH first row and first column AT THE SAME TIME

%3CLINGO-SUB%20id%3D%22lingo-sub-2277520%22%20slang%3D%22en-US%22%3EExcel%20Web%20App%20-%20freeze%20BOTH%20first%20row%20and%20first%20column%20AT%20THE%20SAME%20TIME%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2277520%22%20slang%3D%22en-US%22%3E%3CP%3E%3CU%3E%3CSTRONG%3ERE%3A%26nbsp%3B%3C%2FSTRONG%3E%20%3CSTRONG%3EMS%20Excel%20%3CFONT%20color%3D%22%23993300%22%3EWEB%20APP%26nbsp%3B%3C%2FFONT%3E%3C%2FSTRONG%3E%3C%2FU%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ECan%20someone%20tell%20me%20the%20secret%20to%20freezing%20at%20the%20same%20time%2C%20together%2C%20simultaneously%20%3CU%3E%3CSTRONG%3Ethe%20first%20row%20and%20first%20column%3C%2FSTRONG%3E%3C%2FU%3E%20in%20an%20MS%20Excel%20%3CSTRONG%3E%3CFONT%20color%3D%22%23993300%22%3EWeb%20App%3C%2FFONT%3E%3C%2FSTRONG%3E%26nbsp%3Bspreadsheet.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSTRONG%3E%3CEM%3EAt%20this%20time%20I%20can%20only%20lock%20one%20at%20a%20time.%3C%2FEM%3E%3C%2FSTRONG%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20find%20it%20hard%20to%20believe%20that%20you%20cannot%20lock%20both%20(rows%20and%20columns)%26nbsp%3B%20at%20the%20same%20time%20on%20%3CSTRONG%3E%3CFONT%20color%3D%22%23993300%22%3EExcel%20Web%20App%3C%2FFONT%3E%3C%2FSTRONG%3E%20version.%26nbsp%3B%20Does%20this%20mean%20that%20no%20one%20builds%20large%20spreadsheet%20%2B50%20rows%20long%20and%20%2B20%20columns%20wide%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20am%20getting%20a%20run%20around%20from%20Microsoft%20to%20get%20an%20answer%20to%20a%20simple%20and%20reasonable%20setting.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2277520%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%20for%20web%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2394138%22%20slang%3D%22en-US%22%3ERe%3A%20Excel%20Web%20App%20-%20freeze%20BOTH%20first%20row%20and%20first%20column%20AT%20THE%20SAME%20TIME%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2394138%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1021202%22%20target%3D%22_blank%22%3E%40RHA1705%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThank%20you!%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThe%20right%20solution.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2277729%22%20slang%3D%22en-US%22%3ERe%3A%20Excel%20Web%20App%20-%20freeze%20BOTH%20first%20row%20and%20first%20column%20AT%20THE%20SAME%20TIME%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2277729%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1021202%22%20target%3D%22_blank%22%3E%40RHA1705%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EDo%20you%20mean%20you%20have%20no%20Freeze%20Panes%20in%20your%20Excel%20for%20Web%3F%3C%2FP%3E%0A%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22image.png%22%20style%3D%22width%3A%20564px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F273688iA52884E176132EF5%2Fimage-size%2Flarge%3Fv%3Dv2%26amp%3Bpx%3D999%22%20role%3D%22button%22%20title%3D%22image.png%22%20alt%3D%22image.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2277695%22%20slang%3D%22en-US%22%3ERe%3A%20Excel%20Web%20App%20-%20freeze%20BOTH%20first%20row%20and%20first%20column%20AT%20THE%20SAME%20TIME%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2277695%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1021202%22%20target%3D%22_blank%22%3E%40RHA1705%3C%2FA%3E%26nbsp%3BTo%20freeze%20both%20the%20first%20row%20and%20first%20column%2C%20select%20cell%20B2.%20On%20the%20view%20tab%2C%20select%20%22Freeze%20Panes%22.%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22Screenshot%202021-04-19%20at%2009.31.14.png%22%20style%3D%22width%3A%20511px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F273677iFDE993DEA6C00178%2Fimage-dimensions%2F511x222%3Fv%3Dv2%22%20width%3D%22511%22%20height%3D%22222%22%20role%3D%22button%22%20title%3D%22Screenshot%202021-04-19%20at%2009.31.14.png%22%20alt%3D%22Screenshot%202021-04-19%20at%2009.31.14.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3EThis%20freezes%20the%20rows%20above%20and%20columns%20towards%20the%20left%20from%20the%20active%20cell.%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2815116%22%20slang%3D%22en-US%22%3ERe%3A%20Excel%20Web%20App%20-%20freeze%20BOTH%20first%20row%20and%20first%20column%20AT%20THE%20SAME%20TIME%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2815116%22%20slang%3D%22en-US%22%3EYou%20should%20have%20thousands%20of%20likes%20for%20this!!!%20THANK%20YOU!!!!%3C%2FLINGO-BODY%3E
New Contributor

RE:  MS Excel WEB APP 

 

Can someone tell me the secret to freezing at the same time, together, simultaneously the first row and first column in an MS Excel Web App spreadsheet.

 

At this time I can only lock one at a time.

 

I find it hard to believe that you cannot lock both (rows and columns)  at the same time on Excel Web App version.  Does this mean that no one builds large spreadsheet +50 rows long and +20 columns wide?

 

I am getting a run around from Microsoft to get an answer to a simple and reasonable setting.

 

 

 

 

4 Replies

@RHA1705 To freeze both the first row and first column, select cell B2. On the view tab, select "Freeze Panes".

Screenshot 2021-04-19 at 09.31.14.png

This freezes the rows above and columns towards the left from the active cell. 

@RHA1705 

Do you mean you have no Freeze Panes in your Excel for Web?

image.png

@RHA1705 

 

Thank you!

 

The right solution.

You should have thousands of likes for this!!! THANK YOU!!!!