If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Keep Top Row Heading for printing multiple pages
I have a 5 column worksheet with hundred of rows of
data. All of the columns come out in print preview mode in landscape mode. It is about a 20 page document. I want to keep the top row of info that describes what is in each column to print on each page that is printed...any help? thanks, |
#2
|
|||
|
|||
Keep Top Row Heading for printing multiple pages
G118,
In Excel 2000 (won't guarantee it for other versions). Choose File - Page Setup, under the Sheet tab put your cursor in the Rows to repeat at top: field and select the desired repeating rows. Dan E "G118" wrote in message ... I have a 5 column worksheet with hundred of rows of data. All of the columns come out in print preview mode in landscape mode. It is about a 20 page document. I want to keep the top row of info that describes what is in each column to print on each page that is printed...any help? thanks, |
Thread Tools | |
Display Modes | |
|
|