How about doing each worksheet's header/footer separately?

Don't group the worksheets before you do File|page setup.

MethodMadness wrote:

Hello,

I am trying to print multiple tabs in a single worksheet with page numbers
using the Header/Footer function. The problem is that each tab has different
page setups for size and number of pages, and each time I try to add the
header and footer across the multiple tabs, Excel 2000 appears to set ALL of
the tabs to the same setting.

What am I doing wrong, and is there any way to fix/circumvent this? Putting
these spreadsheets into Word as objects is not really an option.

Thank you very much for your help!

--

Dave Peterson