Printing an Excel doucument

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?
 
M

MartinW

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
 
Top