Formatting all sheets in a workbook to print the same

I am having trouble getting all sheets in the workbook to print the same. I
have tried selecting all sheets and setting up my header and footer, margins,
etc. But, when I then go to print preview, only the first sheet in the
workbook has held the settings.

You need to do each sheet individually, or copy the sheet that you have set
up and use it as your sheet template.

HTH,
Bernie
MS Excel MVP

"mreed46112" <[email protected]> wrote in message
news:[email protected]...
> I am having trouble getting all sheets in the workbook to print the same.
I
> have tried selecting all sheets and setting up my header and footer,
margins,
> etc. But, when I then go to print preview, only the first sheet in the
> workbook has held the settings.

mrreed

Selecting all sheets and setting up the active one as you describe should
definitely set up all selected sheets the same.

You won't be able to set Print Range and Rows to repeat at top.

All else should set up on each sheet.

I tried with some sheet protected and it still worked for all.

Not much help from me<g> Keep trying.


Gord Dibben Excel MVP

On Wed, 2 Feb 2005 06:27:02 -0800, "mreed46112"
<[email protected]> wrote:

>I am having trouble getting all sheets in the workbook to print the same. I
>have tried selecting all sheets and setting up my header and footer, margins,
>etc. But, when I then go to print preview, only the first sheet in the
>workbook has held the settings.