Scrolling within a section of an excel worksheet

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
 
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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Back
Top