Freeze intermediate rows

[mcastellanos]

Hello,</SPAN>
I know how to freeze top rows/columns and panes.
Is there a way to freeze intermediate rows?
I have title information on rows 1-11 and column header information on rows 12-15. These are the rows I would like to freeze without having to also see rows 1-11.

Is that possible?


Thanks

Miguel</SPAN>

 

[Rick Rothstein]

You can sort of do what you want by splitting the window instead of freezint panes. Select cell A16 and press ALT+ws and then put the cursor over the thick splitting bar that appeared until you see a double (up/down) arrow, then click and drag the bar up so that only 4 rows show on top... then use the vertical scroll bar for the upper pane to bring Row 12 thru 15 into view... then do all your work in the bottom pane.

 

[gsistek]

Also, you can scroll down until row 12 is the top-most row, then freeze panes. It will not scroll up to rows 1-11.

 

[mcastellanos]

Thanks!