Forum Discussion
Freezing rows in the middle of a work sheet
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 ro...
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.
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.
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
Hi, again!
Check this gif with split working. Blessings!
