CREATING HEADERS AND FOOTERS

[Guest]

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

 

[Gord Dibben]

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 File>Page 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

 

[Guest]

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

 

[Peo Sjoblom]

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