G Guest Oct 25, 2007 #1 CAN YOU COPY A HEADER AND FOOTER CREATED IN ONE WORKSHEET TO ALL OTHER SHEETS IN THAT WORKBOOK?
G Gord Dibben Oct 25, 2007 #2 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
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
G Guest Oct 25, 2007 #3 Your help was very much appreciated but your comments on capitals difficult to accept for someone with visual problems. Sorry about your ears!
Your help was very much appreciated but your comments on capitals difficult to accept for someone with visual problems. Sorry about your ears!
P Peo Sjoblom Oct 25, 2007 #4 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
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
