If an existing sheet is already setup, you could group the sheets.
And with the good one active
file|page setup
click ok
and then ungroup the sheets.
Lots of those print settings get copied to the other sheets in the group.
It can be lots easier to copy the worksheet that's setup, then make changes to
the data--instead of starting with an empty worksheet.
If you have lots of these to do, you may want to make a worksheet and use it as
a template for other new worksheets.
M Kan wrote:
In Excel 2003, I thought there was a shortcut key for applying sheet level
formatting (e.g., margins, headers, footers, etc) from one sheet to another,
but can't seem to find it anywhere.
--
Tips for Excel, Word, PowerPoint and Other Applications
http://www.kan.org/tips
--
Dave Peterson