How do I retain print setup when copying a worksheet?
When copying from one worksheet to another, the print margins, header,footer,
etc. does not copy over. I'm doing a straight copy/paste. I've also tried the paste special command. Your help is appreciated. |
Hi Bryan
as these things belong to the worksheet itself you'll need to duplicate the worksheet not just copy & paste the data. If it is in the same book, click on the sheet tab that you want to duplicate, hold down your control key and drag the sheet tab (either left or right) with the mouse - let the mouse go and then the control key ... the sheet will then be duplicated. if it is between workbooks, ensure that you have both books open, right mouse click on the sheet tab of the sheet to duplicate and choose move or copy sheet . TICK the Create a copy box and then from the drop down choose the book, click on the list to indicate where you want the sheet to go and click the OK button. Hope this helps Cheers JulieD "Bryan" <Bryan @discussions.microsoft.com wrote in message ... When copying from one worksheet to another, the print margins, header,footer, etc. does not copy over. I'm doing a straight copy/paste. I've also tried the paste special command. Your help is appreciated. |
All times are GMT +1. The time now is 03:44 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com