Can a header be applied once to a workbook & print on each page?

I would like to setup a custom header once for a workbook and have to applied
to each page.

<View>
<Header and Footer...>

--
Regards,
Dave


"Christine Sullivan" wrote:

> I would like to setup a custom header once for a workbook and have to applied
> to each page.

Christine

What do you consider as a "page"?

A printed page or a worksheet?

If you mean worksheets, right-click on the first sheet tab and "select all
sheets"

Set up the custom header for the active sheet and will be done to all.

DO NOT FORGET to right-click and "Ungroup sheets" when done the setup.

If page means printed pages from one worksheet, just place the header on that
sheet.

All pages will have the header.


Gord Dibben MS Excel MVP

On Tue, 8 Aug 2006 10:08:01 -0700, Christine Sullivan <Christine
Sullivan@discussions.microsoft.com> wrote:

>I would like to setup a custom header once for a workbook and have to applied
>to each page.