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...
Forum Discussion
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.
Rebecca_DH if you want rows to repeat at the top of a Report PAGE then you can use
Page Layout
Print Titles
[rows to repeat at top] $20:$20
where 20 is the number (s) of the row to repeat