Prev: macro to hide columns with zero values?
Next: How to set default not to auto correct word?
From: JJ on 23 Mar 2010 12:08
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.
From: Gord Dibben on 23 Mar 2010 12:31
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(a)ARC <JJARC(a)discussions.microsoft.com>
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.

From: JJ on 23 Mar 2010 14:03
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(a)ARC <JJARC(a)discussions.microsoft.com>
> 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.
>
> .
>
 | 
Pages: 1
Prev: macro to hide columns with zero values?
Next: How to set default not to auto correct word?