How can I copy print formatting to multiple worksheets that have already been
created? Can I copy and paste print setup formatting or is there a way to
select multiple worksheets and globally set print formats all at once?

Right-click on a sheet and "select all sheets"

Do your print setup on the active sheet and will be done to all sheets.

NOTE: you cannot set Print Range and Rows to repeat at top on Grouped sheets.

You would require macro code for those two items. All else can be replicated.


Gord Dibben MS Excel MVP

On Tue, 6 Feb 2007 16:05:00 -0800, JD wrote:

How can I copy print formatting to multiple worksheets that have already been
created? Can I copy and paste print setup formatting or is there a way to
select multiple worksheets and globally set print formats all at once?

Thanks for the reply Gord. However, when I right click on one of the open
sheets I do not get a "select all" option. Any thoughts?

"Gord Dibben" wrote:

Right-click on a sheet and "select all sheets"

Do your print setup on the active sheet and will be done to all sheets.

NOTE: you cannot set Print Range and Rows to repeat at top on Grouped sheets.

You would require macro code for those two items. All else can be replicated.


Gord Dibben MS Excel MVP

On Tue, 6 Feb 2007 16:05:00 -0800, JD wrote:

How can I copy print formatting to multiple worksheets that have already been
created? Can I copy and paste print setup formatting or is there a way to
select multiple worksheets and globally set print formats all at once?

You need to right-click on the sheet's tab, not on the content of the sheet.
--
David Biddulph

"JD" wrote in message
...
Thanks for the reply Gord. However, when I right click on one of the open
sheets I do not get a "select all" option. Any thoughts?

"Gord Dibben" wrote:

Right-click on a sheet and "select all sheets"

Do your print setup on the active sheet and will be done to all sheets.

NOTE: you cannot set Print Range and Rows to repeat at top on Grouped
sheets.

You would require macro code for those two items. All else can be
replicated.


Gord Dibben MS Excel MVP

On Tue, 6 Feb 2007 16:05:00 -0800, JD
wrote:

How can I copy print formatting to multiple worksheets that have already
been
created? Can I copy and paste print setup formatting or is there a way
to
select multiple worksheets and globally set print formats all at once?

Thanks for the correction David.

I left out the "tab" part

Gord

On Wed, 7 Feb 2007 08:15:22 -0000, "David Biddulph"
wrote:

You need to right-click on the sheet's tab, not on the content of the sheet.