Print Settings

[Jeff R]

Is there a way to setup default print settings for new
excel files or worksheets?
Also, is there a way to copy print settings from worksheet
to worksheet?
The settings I am referring to are print area, margins,
headers and footers, etc.

 

[Richard O. Neville]

For new documents, you could construct a template with the settings you
want. You can copy print settings by copying the entire worksheet.
Right-click the sheet tab name, select Move or Copy, and proceed. The copied
document will have both the data and all the formatting of the original.
Delete the data and you will still have the formatting, including print
settings.