Losing Print Setting in Copy

[gard0128]

When I copy a worksheet from one file to another, I lose my print settings (including my print area, margins, page breaks, etc)

Is there a way to preserve these settings when copying a worksheet from one Excel file to another?

Thanks.

 

[rigel7]

You are not going to be able to transfer everything at one go. But, to transfer Page Setup values, this is what you need to do. Open the original worksheet. Go to file Page setup. Click OK. Go to the worksheet copy, Press CTRL/y.