Printing an Excel doucument

  • Thread starter Thread starter Richard Mahan
  • Start date Start date
R

Richard Mahan

In this example, I have a document of 100 pages, when I print the
document, the column headers only print on the first page and not the
subsequent pages. also I would like all the pages to be numbered. is therea
fix for this?
 
Hi Richard,

For your first question goto File>Page Setup>Sheet tab and
look for the option 'Rows to repeat at top'

For your second question goto View>Header and Footer and
look at the &[page] and &[pages] options in your footer.

HTH
Martin
 
You must log in or register to reply here.

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

printing frozen column on each page 2
Printing a large/long spreadsheet on legal size paper problem 1
Excel 2007 print option gone 1
Excel 2007 printing does not scale properly 5
How to freeze a range in excel 2003and 2007 1
Access Page Header with merge field 0
header not printing in every section 1
Excel 2002 Column Widths & Printing 3

Back
Top