Select all of the sheets that you want to apply the header to before creating
the header.

Hold down the CTRL key and click each sheet, or select the first sheet, hold
down SHIFT then select last sheet to select all in between.

Now, whatever you do to one sheet, happens to all of them.

Right click the sheet tab and select "Ungroup Sheets" to get back to
editting a single sheet.

HTH,
Elkar


"jenny28" wrote:


I have a file with 10 Sheets, and I want them to ALL have the same
Header. Does anyone know how to do this, and have it automaticallty
update all the Sheets when I update one? I know you can do the whole
thing where you do "repeat rows at top", but this isn't a row I want to
repeat, it's the Header. Does anyone know how to do that?

thx!
j28


--
jenny28
------------------------------------------------------------------------
jenny28's Profile: http://www.excelforum.com/member.php...o&userid=31034
View this thread: http://www.excelforum.com/showthread...hreadid=507018