SOLVED
Home

Freezing multiple rows

%3CLINGO-SUB%20id%3D%22lingo-sub-358362%22%20slang%3D%22en-US%22%3EFreezing%20multiple%20rows%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-358362%22%20slang%3D%22en-US%22%3E%3CP%3EI%20just%20need%20to%20freeze%20the%20top%203%20rows%20in%20a%20spreadsheet.%20Easy%3A%20select%20the%204th%20row%2C%20click%20'Freeze%20Panes'%20and%20choose%20the%20'Freeze%20rows'%20option.%20Except%20that%20the%20option%20isn't%20there%20-%20the%20only%20option%20offered%20is%20to%20freeze%20the%20top%20row.%3C%2FP%3E%3CP%3EI%20am%20using%20Office%20365%2C%20so%20my%20Excel%20is%20a%20current%20version.%20And%20I%20am%20working%20in%20Normal%20View.%20So%20I%20don't%20understand%20why%20I%20cannot%20freeze%20multiple%20rows%20any%20more!%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20style%3D%22width%3A%20948px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F84693i33050FFCC4454CAE%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20alt%3D%22freeze_panes.jpg%22%20title%3D%22freeze_panes.jpg%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-358362%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-358558%22%20slang%3D%22en-US%22%3ERe%3A%20Freezing%20multiple%20rows%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-358558%22%20slang%3D%22en-US%22%3E%3CP%3EAbsolutely%20brilliant.%20Thank%20you%20so%20much.%20I've%20used%20Excel%20for%20more%20than%2020%20years%20and%20I'm%20pretty%20sure%20this%20method%20is%20new%20-%20or%2C%20at%20least%2C%20newish.%20But%20it's%20great%20to%20find%20out%20there%20really%20is%20a%20way.%20Thank%20you%20for%20pointing%20the%20way.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-358383%22%20slang%3D%22en-US%22%3ERe%3A%20Freezing%20multiple%20rows%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-358383%22%20slang%3D%22en-US%22%3E%3CP%3EUnfreeze%20the%20rows%2Fcolumns.%20Then%20if%20you%20want%20to%20freeze%20more%20than%20the%20top%20and%20more%20than%20the%20first%20column%2C%20go%20to%20the%20cell%20below%20the%20row%20you%20want%20to%20freeze%20and%20after%20the%20column%20you%20want%20to%20freeze%20and%20the%20select%20Freezes%20panes.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20style%3D%22width%3A%20999px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F84695i6608396A9C066431%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20alt%3D%22freezerowsandcolumns.png%22%20title%3D%22freezerowsandcolumns.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E
David_Townsend_Jones
New Contributor

I just need to freeze the top 3 rows in a spreadsheet. Easy: select the 4th row, click 'Freeze Panes' and choose the 'Freeze rows' option. Except that the option isn't there - the only option offered is to freeze the top row.

I am using Office 365, so my Excel is a current version. And I am working in Normal View. So I don't understand why I cannot freeze multiple rows any more!

freeze_panes.jpg

2 Replies

Unfreeze the rows/columns. Then if you want to freeze more than the top and more than the first column, go to the cell below the row you want to freeze and after the column you want to freeze and the select Freezes panes.

 

freezerowsandcolumns.png

Solution

Absolutely brilliant. Thank you so much. I've used Excel for more than 20 years and I'm pretty sure this method is new - or, at least, newish. But it's great to find out there really is a way. Thank you for pointing the way.

Related Conversations
Tabs and Dark Mode
cjc2112 in Discussions on
18 Replies
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies
flashing a white screen while open new tab
cntvertex in Discussions on
11 Replies
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
28 Replies