LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #2   Report Post  
clnickson
 
Posts: n/a
Default

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.



"jesstravmad" wrote:

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.

 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Rename Excel Worksheet Dragon Excel Discussion (Misc queries) 6 June 20th 05 03:19 PM
Excel Range Value issue (Excel 97 Vs Excel 2003) Keeno Excel Discussion (Misc queries) 2 June 13th 05 02:01 PM
insert picture in header section of excel worksheet bhavini Excel Discussion (Misc queries) 4 February 22nd 05 08:43 PM
Weekly Transaction Processing Ralph Howarth Excel Worksheet Functions 4 January 19th 05 05:37 AM
How do I replace a worksheet with another worksheet in excel Ammnon Excel Worksheet Functions 1 January 12th 05 10:48 AM


All times are GMT +1. The time now is 08:38 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"