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
 

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

Similar Threads

Excel Fit to page print options in Excel 1
Printing a Different Row Heading Mid-way through a Spreadsheet 1
Repeat Row at Top of Worksheet 2
Excel Page orientation 1
rows to repeat at the top 4
Print Column Heads WITHOUT Excel Column Lables 1
Worksheet 2
Hide columns based on row values 2

Back
Top