Creating Headers for Multiple Sheet Tabs

[Tom Engelhorn]

I know how to create a Header in Excel, but I would like
to be able to create one Header for multiple sheet tabs
without having to perform a copy and paste. Any thoughts
out there?

Thanks for your assistance

Tom Engelhorn
(e-mail address removed)

 

[Dave R.]

Hold down CTRL and click on the sheet tabs, which will select them (you can
also use shift to select from one sheet to another and it will select those
inbetween). You will then have grouped worksheets, and can go to
view>header/footer, and setup the header there. It will be done on all
sheets.

Then you can click on any individual sheet (other than the one you're on)
and it will unselect the sheets.

You can do the same to put contents in the same cell of various worksheets.

 

[Ken Wright]

And make 100% sure you UNGROUP afterwards!!!!!!!!!!!! else you will not be
amused Change a cell on one and you do it to them all.

 

[Gord Dibben]

Tom

Right-click on a sheet tab then "Select all Sheets"

Set up the header for the active sheet and it will be replicated on each sheet
in the selection.

DO NOT FORGET to ungroup the sheets when done. What you do to one is being
done to all. Can lead to disatrous results if not ungrouped.

When grouped, you will se the word [Group] next to the filename in Title Bar.

Gord Dibben Excel MVP