Copy worksheet

[Scott]

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

 

[Alan]

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.