How do I repeat same custom header for entire workbook

J

JillyB

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
 
D

Dave Peterson

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.
 
Top