CAN YOU COPY A HEADER AND FOOTER CREATED IN ONE WORKSHEET TO ALL OTHER SHEETS
IN THAT WORKBOOK?
--
CHRISTINE

Please drop the all caps............hard on the ears and difficult to read.

You can "group" the sheets by right-click on the sheet tab with the
header/footer and "select all sheets".

Select FilePage Setup and affirm that the header/footer is what you want then
OK you way out.

All sheets will have that setup done.

Don't forget to right-click and "ungroup" the sheets when complete.

If you want just some sheets in the group use CTRL + click on non-contiguous
sheets.

If you want a series of sheets, SHIFT + Click.


Gord Dibben MS Excel MVP


On Thu, 25 Oct 2007 08:36:07 -0700, CHRISTINE
wrote:

CAN YOU COPY A HEADER AND FOOTER CREATED IN ONE WORKSHEET TO ALL OTHER SHEETS
IN THAT WORKBOOK?

Your help was very much appreciated but your comments on capitals difficult
to accept for someone with visual problems. Sorry about your ears!
--
CHRISTINE


"CHRISTINE" wrote:

CAN YOU COPY A HEADER AND FOOTER CREATED IN ONE WORKSHEET TO ALL OTHER SHEETS
IN THAT WORKBOOK?
--
CHRISTINE

Never heard that before, in fact I have read the opposite, that visually
impaired people find it easier to read lower case which doesn't surprise me
since most people find it easier to read lower caps


--


Regards,


Peo Sjoblom


"CHRISTINE" wrote in message
...
Your help was very much appreciated but your comments on capitals
difficult
to accept for someone with visual problems. Sorry about your ears!
--
CHRISTINE


"CHRISTINE" wrote:

CAN YOU COPY A HEADER AND FOOTER CREATED IN ONE WORKSHEET TO ALL OTHER
SHEETS
IN THAT WORKBOOK?
--
CHRISTINE