How do I repeat same custom header for entire workbook
I am trying to repeat the same custom header in every worksheet of my
workbook which is scanned in logo but at the moment I have to set it up for every worksheet- Is there anyway it can be repeated automatically on every worksheet in ther book |
How do I repeat same custom header for entire workbook
Try grouping the worksheets first.
Click on the first tab and ctrl-click on subsequent tabs (or right click on any and choose Select all sheets). Then do the page setup. Lots of these settings will be applied to all the sheets that are grouped. Be careful. Make sure you ungroup the sheets when you're done. Almost all the changes you make to a grouped sheet will affect the other sheets in that group. JillyB wrote: I am trying to repeat the same custom header in every worksheet of my workbook which is scanned in logo but at the moment I have to set it up for every worksheet- Is there anyway it can be repeated automatically on every worksheet in ther book -- Dave Peterson |
All times are GMT +1. The time now is 01:12 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com