transferring headers and footers



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.



Peo Sjoblom

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question