apply same custom header to all sheets in a workbook

  • Thread starter Thread starter jchoy
  • Start date Start date
J

jchoy

Is there a quick way to apply the same custom header to
all sheets in a workbook?
 
Hi!

Not clear what you want.

If it is a header (as in View> Headers and footers) this route wil
give you headers which print out on each sheet.

If it is a heading which is visible on screen for each sheet then:

select the first worksheet you want the heading on:
with the shift key depressed, select he last sheet for the heading.

Now put the heading in the visible sheet (formats, text etc).
This will replicate in the other selected sheets.

Exit by clicking on one of the other worksheets.
BE CAREFUL NOT TO LEAVE THE GROUPING ON.

You can tell when worksheets are grouped for this kind of mass editing
Excel puts [Group] alongside the file name on the top bar of th
screen.

Al
 
You must log in or register to reply here.

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

Merge Multiple workbook sheets into one workbook 0
Header and Footer 5
HEADERS HELP PLEASE! 1
Excel Header and Footer 1
Apply Conditional Format to all sheets in same workbook 4
Need macro to consolidate all sheets in workbook 1
howto put the same header on all worksheets of workbook 6
Different headers, same footers on multiple worksheets 2

Back
Top