I have a workbook with multiple worksheets and I want to use page setup to
define the printing instructions for all the sheets simultaneously. All the
instructions for all the worksheets will be the same (margins, footers, etc.).

I highlight all the sheets but only the first one seems to acknowledge the
instructions.

The grouped sheets won't take any print settings or just some print
settings?

Rows to repeat at top and printrange cannot be set on grouped sheets.


Gord Dibben MS Excel MVP

On Tue, 23 Mar 2010 09:08:01 -0700, JJ@ARC
wrote:

I have a workbook with multiple worksheets and I want to use page setup to
define the printing instructions for all the sheets simultaneously. All the
instructions for all the worksheets will be the same (margins, footers, etc.).

I highlight all the sheets but only the first one seems to acknowledge the
instructions.

The settings that I have tried are page margins, footers, footer fonts, and
orientation. The first sheet accepted the settings but none of the other
sheets.

"Gord Dibben" wrote:

The grouped sheets won't take any print settings or just some print
settings?

Rows to repeat at top and printrange cannot be set on grouped sheets.


Gord Dibben MS Excel MVP

On Tue, 23 Mar 2010 09:08:01 -0700, JJ@ARC
wrote:

I have a workbook with multiple worksheets and I want to use page setup to
define the printing instructions for all the sheets simultaneously. All the
instructions for all the worksheets will be the same (margins, footers, etc.).

I highlight all the sheets but only the first one seems to acknowledge the
instructions.

.