Diane


Select first sheet.

Right-click on tab and "select all sheets".

Set up your custom footer on the active worksheet and this set up will be
transferred to all worksheets.

DO NOT FORGET to ungroup sheets when done. What is done to activesheet will be
done to all sheets in the group.


Gord Dibben MS Excel MVP

On Wed, 12 Apr 2006 13:13:03 -0700, Diane <Diane@discussions.microsoft.com>
wrote:

>I have a custom header in one Excel worksheet that I need to copy into
>several other worksheets. Is there a way to do this without reentering the
>information separately for each sheet?

Gord Dibben MS Excel MVP