Choose all of the sheets you want the same header/footer on as a group
(search Help for Group) and then make changes to the Header/Footers and all
sheets will be changed at once. Be careful, because pretty much anything
else you do while the sheets are still grouped will be done to them all -
like deleting a formula or entering something in a cell.

Now, if I misinterpreted your question and you want the same rows from the a
sheet to print on multiple sheets (as when a worksheet contains multiple
pages when printed), then use File | Page Setup | [Sheet] tab and enter the
Rows To Repeat area on that tab.

"Pamela Martin" wrote:

I tried using Views - but it didn't take put the Heading or footer on the
next worksheet.