Home |
Search |
Today's Posts |
#1
|
|||
|
|||
copy page setup from worksheet to another within workbook
I want to copy my page setups from one worksheet to another within a
workbook. When I copy and paste, all the worksheet stuff is there but not the page setups and I have to re-do them all over again. |
#2
|
|||
|
|||
Select the sheet with the page setup you want then using the shift or control
key select the sheet(s) you want with the same page setup, then select File, Page Setup, then OK and all the worksheets will inherit the page setup of the first sheet selected. Gary "Fanny" wrote: I want to copy my page setups from one worksheet to another within a workbook. When I copy and paste, all the worksheet stuff is there but not the page setups and I have to re-do them all over again. |
#3
|
|||
|
|||
Thank you so much Gary, this is going to save me alot of work.
"Gary Rowe" wrote: Select the sheet with the page setup you want then using the shift or control key select the sheet(s) you want with the same page setup, then select File, Page Setup, then OK and all the worksheets will inherit the page setup of the first sheet selected. Gary "Fanny" wrote: I want to copy my page setups from one worksheet to another within a workbook. When I copy and paste, all the worksheet stuff is there but not the page setups and I have to re-do them all over again. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
In excel how do I copy page setup format from one wsht to another | Excel Discussion (Misc queries) | |||
how dio i copy page setup formats from 1 spreadsheet to another? | New Users to Excel | |||
Can I copy a worksheet with its page setup and print formats? | Excel Discussion (Misc queries) | |||
copy a cell to another worksheet? | Excel Worksheet Functions | |||
How do I copy a cell (content AND format) from one worksheet to a. | Excel Worksheet Functions |