Forum Discussion
Solved
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.
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!
