Freezing rows in the middle of a work sheet

%3CLINGO-SUB%20id%3D%22lingo-sub-198329%22%20slang%3D%22en-US%22%3EFreezing%20rows%20in%20the%20middle%20of%20a%20work%20sheet%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-198329%22%20slang%3D%22en-US%22%3E%3CP%3EI%20have%20a%20problem%20with%20my%20work%20sheet.%3C%2FP%3E%3CP%3Ethe%20First%2035%20lines%20are%20data%20that%20is%20not%20needed%20to%20freeze%2C%20but%20there%20is%20that%20date%20row%20which%20I%20need%20to%20freeze%2C%20only%20that.%3C%2FP%3E%3CP%3ESince%20the%20list%20is%20very%20long%20over%202000%20rows%20long%20I%20need%20the%20date%20to%20freeze%20so%20that%20when%20I%20scroll%20down%20the%20date%20remains%20frozen.%3C%2FP%3E%3CP%3EI%20have%20tried%20Menu%20View%20and%20clicked%20on%20freeze%20panes%20and%20selected%20Freeze%20panes%20only%20selected.%3C%2FP%3E%3CP%3EI%20only%20select%20what%20I%20need%20to%20freeze%20but%20the%20whole%2038%20rows%20freeze%20which%20are%20not%20relevant.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EIs%20there%20anyone%20kindly%20who%20has%20a%20solution%20to%20the%20above.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EMany%20thanks%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-198329%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-198735%22%20slang%3D%22en-US%22%3ERe%3A%20Freezing%20rows%20in%20the%20middle%20of%20a%20work%20sheet%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-198735%22%20slang%3D%22en-US%22%3E%3CP%3EHi%2C%20again!%3C%2FP%3E%3CP%3E%3CBR%20%2F%3ECheck%20this%26nbsp%3Bgif%20with%20split%20working.%26nbsp%3B%20Blessings!%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-198538%22%20slang%3D%22en-US%22%3ERe%3A%20Freezing%20rows%20in%20the%20middle%20of%20a%20work%20sheet%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-198538%22%20slang%3D%22en-US%22%3E%3CP%3EHi%20there%20tried%20it%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EIt%20is%20not%20selecting%20what%20I%20need%20I%20just%20have%20one%20line%20of%20row%20that%20needs%20to%20be%20frozen.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EIt%20is%20freezing%20the%20whole%20top%20row%20as%20well%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3Eexample%20from%20A12%20to%20a%2036%20needs%20to%20be%20static%20the%20rest%20can%20go%20while%20scrolling%20down%20or%20up.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-198352%22%20slang%3D%22en-US%22%3ERe%3A%20Freezing%20rows%20in%20the%20middle%20of%20a%20work%20sheet%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-198352%22%20slang%3D%22en-US%22%3E%3CP%3EHi%2C%20Karol!%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EUse%20the%20split%20tool%20in%20View%20Menu%20at%20the%20ribbon.%26nbsp%3B%20Check%20this%20link%20for%20your%20support%3A%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CEM%3E%3CSTRONG%3E%3CA%20href%3D%22https%3A%2F%2Fwww.excel-easy.com%2Fexamples%2Fsplit.html%22%20target%3D%22_blank%22%20rel%3D%22nofollow%20noopener%20noreferrer%22%3Ehttps%3A%2F%2Fwww.excel-easy.com%2Fexamples%2Fsplit.html%3C%2FA%3E%3C%2FSTRONG%3E%3C%2FEM%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EBlessings!%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2112723%22%20slang%3D%22en-US%22%3ERe%3A%20Freezing%20rows%20in%20the%20middle%20of%20a%20work%20sheet%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2112723%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F147710%22%20target%3D%22_blank%22%3E%40karol%20polubinski%3C%2FA%3E%26nbsp%3BTook%20me%20a%20while%20to%20figure%20this%20one%20out%20too.%26nbsp%3B%20You%20want%20to%20select%20the%20row%20that%20is%20directly%20BELOW%20the%20data%20row%20you%20want%20to%20actually%20%22freeze%22%2C%20and%20select%20%22freeze%20pane%22.%26nbsp%3B%20Sounds%20counterintuitive%2C%20I%20know.%26nbsp%3B%20But%20it%20works.%3C%2FP%3E%3C%2FLINGO-BODY%3E
Contributor

I have a problem with my work sheet.

the First 35 lines are data that is not needed to freeze, but there is that date row which I need to freeze, only that.

Since the list is very long over 2000 rows long I need the date to freeze so that when I scroll down the date remains frozen.

I have tried Menu View and clicked on freeze panes and selected Freeze panes only selected.

I only select what I need to freeze but the whole 38 rows freeze which are not relevant.

 

Is there anyone kindly who has a solution to the above.

 

Many thanks

8 Replies

Hi, Karol!

 

Use the split tool in View Menu at the ribbon.  Check this link for your support:

 

https://www.excel-easy.com/examples/split.html

 

Blessings!

 

Hi there tried it,

 

It is not selecting what I need I just have one line of row that needs to be frozen.

 

It is freezing the whole top row as well

 

example from A12 to a 36 needs to be static the rest can go while scrolling down or up.

Hi, again!


Check this gif with split working.  Blessings!

@karol polubinski Took me a while to figure this one out too.  You want to select the row that is directly BELOW the data row you want to actually "freeze", and select "freeze pane".  Sounds counterintuitive, I know.  But it works.

I always wanted to freeze only the middle rows excluding the top rows in the spreadsheet. Finally, I could do it today. You scroll the spreadsheet down until you see the top of the rows you want to freeze and make sure you keep it on top in the spreadsheet and choose the row right below the last row you want to freeze and click on freeze panes.  This should work. You don't need to install anything.  @karol polubinski 

Freeze panes work only TOP and LEFT portion of the spreadsheet.
Hi,

It is very easy.

1. Select row just above the one u want to freeze
Press Shift & Hold it
2. Select the row just below the one u want to freeze
Release the Hold button
3. Click on View top (towards the top centre of the screen
4. Select First option from Freeze Panes
5. Smile!

@karol polubinski  It should not be hard for Microsoft to add Freeze =$35 to their application, because they use this notation for conditional formatting, to demark ranges and rows to repeat when printing.  

 

Until then, I'd insert a blank row at the top and use a formula to copy the value in each column in row 35 to row 1 (=A35)  copy that across all columns in row 1, then freeze row 1.   

 

In my case, that solution doesn't work because I'm really looking for report header functionally - a place to keep descriptive info with the data that takes up 2 or 3 rows similar to what you can place in the print header.  I'm understand that when the end user gets the spreadsheet, they will want to maximize the screen space and only freeze the column header row, but I don't want to release the data without explanation.