If it's the same cell in each worksheet and the sheets are all in order that
you want to copy to, copy the cell, select the left-most sheet, press shift,
select the right-most sheet, select the desired cell, press Ctrl + V. Don't
forget to right click any grouped sheet tab and select Ungroup Sheets from
the Ply menu.

HTH

--
Regards,
Zack Barresse, aka firefytr
To email, remove NOSPAM


"Diane" wrote in message
...
I have a custom header in one Excel worksheet that I need to copy into
several other worksheets. Is there a way to do this without reentering
the
information separately for each sheet?