In excel how do I copy page setup format from one wsht to another

[Guest]

Excel 2003 Professional
I have made multiple sheets in workbook, copied formatted sheet1 to other
sheets, but the printing or page setup does not copy to other sheets. I want
to be able to copy the page setup format to all other sheets in the workbook.

 

[Paul B]

Richard, 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 now all sheets should have the same page
settings!


--
Paul B
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from it
Feedback on answers is always appreciated!
Using Excel 2002 & 2003

Excel 2003 Professional
I have made multiple sheets in workbook, copied formatted sheet1 to other
sheets, but the printing or page setup does not copy to other sheets. I want
to be able to copy the page setup format to all other sheets in the

workbook.