Worksheet settings

  • Thread starter Thread starter Donna
  • Start date Start date
D

Donna

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.
 
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
 
Back
Top