How do you create a new worksheet with identical setup (margins, fonts, etc., as my first worksheet?
I created a worksheet that has specific margins in landscape orientation, after I add a new worksheet, I cut the correct worksheet and paste it into the new worksheet. When I hit print preview, everything is off.
After you have setup your base sheet, right click the sheet tab and select ‘Move or Copy’.
When the Move of Copy window appears, check the ‘Create a copy’ check box and select where you wish it to be added to the workbook.
An identical copy will be inserted.
November 2nd, 2009 at 7:36 pm
After you have setup your base sheet, right click the sheet tab and select ‘Move or Copy’.
When the Move of Copy window appears, check the ‘Create a copy’ check box and select where you wish it to be added to the workbook.
An identical copy will be inserted.
References :