SOLVED

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%3CLINGO-SUB%20id%3D%22lingo-sub-1196551%22%20slang%3D%22en-US%22%3ERe%3A%20Freezing%20multiple%20rows%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1196551%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F2552%22%20target%3D%22_blank%22%3E%40Tanya%20Denton%3C%2FA%3E%26nbsp%3B%20That%20response%20works%20fine%20if%20you%20want%20to%20freeze%20rows%20and%20columns.%26nbsp%3B%20But%20I%20can't%20find%20any%20way%20to%20freeze%20a%20specific%20row%2C%20no%20columns.%26nbsp%3B%20I%20use%20data%20sheets%20with%20headings%20on%20the%20second%20row%20and%20I%20need%20them%20visible%20when%20I%20scroll%20down.%26nbsp%3B%20Used%20to%20be%20so%20easy%20in%20old%20Office.%26nbsp%3B%20Please%20help%20me%20as%20this%20is%20crucial%20in%20my%20work.%26nbsp%3B%20thanks!%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1196760%22%20slang%3D%22en-US%22%3ERe%3A%20Freezing%20multiple%20rows%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1196760%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F568777%22%20target%3D%22_blank%22%3E%40brigsby%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3EJust%20select%20cell%20A3%20and%20select%20Window%2C%20Freeze%20Panes.%20Then%2C%20row%201%20and%202%20will%20be%20frozen%20but%20no%20columns.%20Has%20been%20like%20that%20for%20many%20years.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1199851%22%20slang%3D%22en-US%22%3ERe%3A%20Freezing%20multiple%20rows%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1199851%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%3B%20I%20had%20tried%20that%20but%20somehow%20it%20didn't%20work.%26nbsp%3B%20But%20now%20it%20does!%26nbsp%3B%20Thanks%20so%20much%20for%20confirming%20that!%26nbsp%3B%20(this%20is%20my%20first%20year%20using%20Office%20365%2C%20so%20adapting%20to%20more%20sophisticated%20program.)%3C%2FP%3E%3C%2FLINGO-BODY%3E
Highlighted
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

5 Replies
Highlighted

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

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

Highlighted

@Tanya Denton  That response works fine if you want to freeze rows and columns.  But I can't find any way to freeze a specific row, no columns.  I use data sheets with headings on the second row and I need them visible when I scroll down.  Used to be so easy in old Office.  Please help me as this is crucial in my work.  thanks!

Highlighted

@brigsby 

Just select cell A3 and select Window, Freeze Panes. Then, row 1 and 2 will be frozen but no columns. Has been like that for many years.

Highlighted

@Riny_van_Eekelen  I had tried that but somehow it didn't work.  But now it does!  Thanks so much for confirming that!  (this is my first year using Office 365, so adapting to more sophisticated program.)