transferring headers and footers

[George]

I have many worksheets in one workbook. I created a standardized header and
footer for the first sheet. How do I transfer (or copy, without retyping)
these headers and footers throughout the entire workbook? Is there a single
command or function to accomplish this?

 

[Peo Sjoblom]

If you group all sheets before you create the headers/footers they will all
be there for all the
sheets. To group the sheets click on the first sheet tab, hold down the
shift key and click on the last sheet tab

Do what you need to do then (this is important) right click any sheet tab
included and select ungroup sheets or else anything you enter in one sheet
will be entered in the rest that are grouped.

--


Regards,


Peo Sjoblom