how dio i copy page setup formats from 1 spreadsheet to another?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I'm using a pivot table to create new spreadsheets that i print out for
distribution. I'd like to copy setups like page margins, rows to repeat at
top, page layout and shrink to fit 1 page by 20
 
Mike,
Caution: the techinque I'm going to share can have unintended
consequences. Let me explain.

If you hold the Ctrl key down and select the tabs of the sheets you
want to perform the same operation on, including Page Setup settings,
anything you do at that point until you unselect the tabs (right click
any selected tab and choose Ungroup) will be done to all the sheets. So
anytime you group select sheets remember to ungroup them, immediately
after doing whatever changes or settings you want them to share.
It is a good idea to practice on a new workbook with some old data so
you get an idea of what happens.

HTH
 
Back
Top