Keep Top Row Heading for printing multiple pages

  • Thread starter Thread starter G118
  • Start date Start date
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,
 
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
 
Back
Top