CREATING HEADERS AND FOOTERS
CAN YOU COPY A HEADER AND FOOTER CREATED IN ONE WORKSHEET TO ALL OTHER SHEETS
IN THAT WORKBOOK? -- CHRISTINE |
CREATING HEADERS AND FOOTERS
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? |
CREATING HEADERS AND FOOTERS
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 |
CREATING HEADERS AND FOOTERS
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 |
All times are GMT +1. The time now is 05:08 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com