I have completed the format of a worksheet and would like to copy to the new
worksheet of the same workbook. The copied worksheet always changes the
format. Can someone advise me how to retain all the formats on new
worksheet.

Thanks,

Scott

Right clip the top left square on the sheet to be copied, the one above '1'
and to the left of 'A', select 'Copy'
Right click the new sheet in the same place, 'Paste'

Regards,
Alan.


"Scott" <NoSpam-(E-Mail Removed)> wrote in message
news:eA%(E-Mail Removed)...
>I have completed the format of a worksheet and would like to copy to the
>new worksheet of the same workbook. The copied worksheet always changes
>the format. Can someone advise me how to retain all the formats on new
>worksheet.
>
> Thanks,
>
> Scott