How do I not print a title in the last page in Excel?

J

John

Hi

Titles (selected rows) are printed in every page in Excel once selected.
Can I omit the printing for the last page? Thanks!
 
J

John

Mine is a title i.e. selected row, not a Header. Does it still work?
Other qn is: what do I do with the script shown - sorry, inept in that area.
 
F

Frank Kabel

Hi
you may thent ry the following:
1. Start recording a macro (Tools - Macros')
2. Print the sheets as you want them (with changing the print area and/or
the pagesetup

After this use this recorded macro for printing
 
Top