Header Format for all worksheets

[Linda RQ]

Hi Everyone,

Using Excel 2003. I have a workbook with 70 worksheets already created. I
want to print these with the tab name as the header. I can get this to work
on one sheet at a time but I would like it to be the same on all worksheets.
Is there a quick way to get this on all sheets at the same time?

Thanks,
Linda

 

[Linda RQ]

Dudes, I got it! I just tried some things I do in other programs....R
clicked and selecte all sheets then could view the header and footer and
inserted the &Tab command there...You guys are great.

Thanks,
Linda