can you set up global headers & footers for all sheets in a file?
 

I have a file that has several worksheets... I want the same header & footer
in all... and then I want to be able to change it globally... for instance,
the header might say "Preliminary Draft", and then when it becomes final, I
want to change it to "Final" without having to go into each worksheet. Is
this possible?

can you set up global headers & footers for all sheets in a file?
 

You should group the sheets together - right click on a sheet tab and
then Group All Sheets. Now, whatever changes you make to one sheet
will be reflected in all of them (so be careful !!). Set up your
Header/Footer as required, and then Ungroup the sheets once you have
finished (right-click a sheet tab again and Ungroup sheets).

Do a similar thing to edit the headers.

Hope this helps.

Pete

On Oct 24, 6:41*pm, Donna wrote:
I have a file that has several worksheets... I want the same header & footer
in all... and then I want to be able to change it globally... for instance,
the header might say "Preliminary Draft", and then when it becomes final, I
want to change it to "Final" without having to go into each worksheet. *Is
this possible?

can you set up global headers & footers for all sheets in a file?
 

1) Click on the tab for Sheet1; Hold SHIFT; Click on the tab for the last
worksheet
or
1A) Right click a worksheet tab and use Select All Select
You worksheets are now "grouped"
2) Use File | Page Setup and set Headers/Footers as required
3) Right click a tab and use Ungroup Sheets
best wishes
--
Bernard V Liengme
Microsoft Excel MVP
http://people.stfx.ca/bliengme
remove caps from email

"Donna" wrote in message
...
I have a file that has several worksheets... I want the same header &
footer
in all... and then I want to be able to change it globally... for
instance,
the header might say "Preliminary Draft", and then when it becomes final,
I
want to change it to "Final" without having to go into each worksheet. Is
this possible?