Scrolling within a section of an excel worksheet

J

jesstravmad

I have an excel sheet that is three sections from top to bottom. For the top
section, I would like to have 10 lines to print, but I want to be able to
have a scroll bar to scroll down and see more rows below. But I only want
those top 10 to print (then the other two sections will print below that).
Is that possible. Thanks.
 
C

clnickson

I'm not sure if I understand you question but this is the answer to what I
think your asking?

To print:
Select File - Page Setup
Select the Sheet tab
Under Print Titles, choose Rows to repeat and select all of the 10 rows you
want repeated on every page of that worksheet when printed

To scroll/view:
Click on the row number shaded in gray directly below the 10th row that you
want to repeat and then choose Window - Freeze Panes. Those rows will freeze
in that position no matter how far you scroll down.
 
Top