changing the page setup for multiple worksheets in a workbook

  • Thread starter Joe Skochdopole
  • Start date
J

Joe Skochdopole

I am trying to change the page set up setiings to fit to 1 page for 56
worksheets within a workbook. Is there an easy way to do this? Can I buy a
program add in to do this for me?
 
G

Guest

Hi

Set the first sheet up as you wish and then click on the tab of the last
sheet - while holding Shift. This will group all of the sheets together. Go
to File / Page Setup and click OK. This will now copy the settings from your
first sheet to the rest.
Don't forget to ungroup the sheets afterwards by right-clicking on a tab and
selecting Ungroup Sheets.
It is good practise to take a copy before you start too!

Andy.
 
E

ewan7279

Hi Joe,

Right click on one of the sheet tabs => select all sheets => page setup =>
fit to page. When finished, right click one of the tabs => ungroup sheets

Ewan
 
B

bbb

by creating a template : open a new file, modify it, then save it as
template.xls in C:\Program Files\Microsoft Office\OFFICE11\XLSTART
it will open every time you run XL
 
Top