Keep Top Row Heading for printing multiple pages

G

G118

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,
 
D

Dan E

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
 

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

Top