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?

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


"Nate" wrote:

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?

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

On Fri, 16 Jun 2006 11:04:01 -0700, Nate wrote:

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?