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

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

Re: Copy using Paste Special

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