Home |
Search |
Today's Posts |
#2
![]() |
|||
|
|||
![]()
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 |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Rename Excel Worksheet | Excel Discussion (Misc queries) | |||
Excel Range Value issue (Excel 97 Vs Excel 2003) | Excel Discussion (Misc queries) | |||
insert picture in header section of excel worksheet | Excel Discussion (Misc queries) | |||
Weekly Transaction Processing | Excel Worksheet Functions | |||
How do I replace a worksheet with another worksheet in excel | Excel Worksheet Functions |