How can I copy page setup settings to other worksheets? Thanks

J

Jeff Graham

I would like to copy the "page setup" info, such as margins, headers/footers,
to other worksheets, but cannot figure out how??
Thanks,
 
P

Paul B

Jeff, here is one way, 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
Please post any response to the newsgroups so others can benefit from it
Feedback on answers is always appreciated!
Using Excel 2002 & 2003
 
Top