How do I link custom headers to one page?

N

Nate

I want to link the headers on multiple pages within one excel file so I can
just change one and the rest will automaticly change, just like when linking
cells between pages. Can anybody tell me how to do this, if it's even
possible?
 
E

Elkar

If you select all of your Sheets at the same time, then anything entered in
cell A1 of one of those sheets will be entered into cell A1 of each selected
sheet.

Hold down the CTRL key and click each sheet you want to select.

HTH,
Elkar
 
G

Gord Dibben

Nate

You can "Group" the sheets by right-click and "select all sheets"

What you do to one sheet will be done to all.

You can mass-change custom Headers/Footers in this manner.


Gord Dibben MS Excel MVP
 
Top