Home |
Search |
Today's Posts |
#1
|
|||
|
|||
In excel how do I copy page setup format from one wsht to another
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. |
#2
|
|||
|
|||
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 "richardT@gale" wrote in message ... 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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
how dio i copy page setup formats from 1 spreadsheet to another? | New Users to Excel | |||
How to copy rows from Excel without losing the row height format | Excel Discussion (Misc queries) | |||
How can I Copy "Page Setup" Settings between Workbooks | Excel Discussion (Misc queries) | |||
How do I maintain my date format, when I copy a sheet, in excel? | Excel Discussion (Misc queries) | |||
excel 2003 page numbering | Excel Worksheet Functions |