Print Setup for Multiple Spreadsheets

[George]

How do I set up multiple spreadsheets in a workbook to all
have the same page setup?
Thanks

 

[Paul B]

George, With the sheet that has the correct settings active, right-click on
the
sheet tab and select "Select All Sheets", then use File/Page Setup and
immediately click OK (don't change anything). Click on some other worksheet
to get you out of "Group" mode and you'll also notice that all sheets have
the same page settings!

--
Paul B
Always backup your data before trying something new
Using Excel 97 & 2000
Please post any response to the newsgroups so others can benefit from it
** remove news from my email address to reply by email **

 

[Judy Freed]

Hold down the CTRL key and click each sheet tab. When all are selected, set
up the print settings. The settings will apply to all selected sheets.

You can also select all of the worksheets by right clicking on any sheet tab
and selecting Select All Worksheets.

Judy Freed