Worksheet settings
 

I have a workbook with over 300 tabs. How do I format all tabs at the same
time? I want to add a header to each page and also set the print area.

Worksheet settings
 

HI Donna
Select your first Tab, press and hold the Shift key then select your last tab,
that will group all your tabs and anything you do in one sheet will be done in
all others.
Don't forget to ungroup them at the end, you can see at the top heading if they
are grouped.
HTH
John
"Donna" wrote in message
...
I have a workbook with over 300 tabs. How do I format all tabs at the same
time? I want to add a header to each page and also set the print area.