How do I repeat same custom header for entire workbook

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

add same header to entire workbook 3
Code to format cells on several worksheets 2
Copy of Header-Footer in Excel 3
How do I set up a single header for a multiple sheet workbook? 2
Insert work sheet with Custom headers 4
Adding Headers and Footer to an Entire Workbook?? 6
Headers & Footers in Excel 1
Headers/Footers from a named range of cells in a worksheet 3

Back
Top