View Single Post
  #2   Report Post  
Tom Ogilvy
 
Posts: n/a
Default

make you special sheet the first in the tab order of all 30 sheets.

Select the special sheet. Hold down the shift key and select the 30th
sheet.

View = Header and Footer

then select your footer and click OK

right click on the sheet tab and select ungroup sheets and all sheets should
have the footer

--
Regards,
tom Ogilvy

"jeff matt" <jeff wrote in message
...
I have a very specific footer setup on one tab of a worksheet. I would

like
to copy that footer setup to other tabs (more than 30) without having to
reenter it on each worksheet. Can it be done?