apply same custom header to all sheets in a workbook

A

AlfD

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
 
Top