Carry formats from an existing worksheet to a new worksheet

[Steveoma]

Can someone tell me how to retain the same formats when I copy data from an existing worksheet to a new worksheet.

I have done this in the past, but my memory is failing me.

Thanks.

 

[Guest]

Right click on the sheet tab, select Move or Copy. Select move to end and check Create a copy box. You'll have to delete any data from the copied sheet.