Archive of Mr Excel Message Board

Back to Edit in Excel archive index
Back to archive home

Copying the formatting of a worksheet

Posted by Saliya Mendis on November 15, 2001 3:58 AM

Hi,

Can you please let me know how I can copy a worksheet and leave the formatting, page setup etc .. intact.

Thankyou
Saliya

Re: Copy using Paste Special

Posted by Rick E on November 15, 2001 6:06 AM

Select the sheet and then use copy, go to the new sheet and select A1 then select Edit/Paste Special and check "Formats" in the Paste Special dialog box and click OK. That should do it.

FYI: You can select the whole sheet by clicking the gray box that is at the top to the Row numbers and to the left of the column letter.

You can also "right" click the mouse button to select "Copy" and "Paste Special".

Good Luck.... Rick E

This archive is from the original message board at www.MrExcel.com.
All contents © 1998-2004 MrExcel.com.
Visit our online store to buy searchable CD's with thousands of VBA and Excel answers.
Microsoft Excel is a registered trademark of the Microsoft Corporation.
MrExcel is a registered trademark of Tickling Keys, Inc.