Copying formatting of worksheets

[Paulasirius]

I would be very grateful for any help on this topic. I would like to be able to copy the complete formatting of a worksheet to a new worksheet. For example, I have a credit card records workbook containing detailed records of my credit card transactions. The workbook contains a separate worksheet for each card. When I get a new credit card I obvoiusly need to create a new worksheet, and I like to keep them all standardised. Ideally, a template would be handy which would contain all the formatting and formulas for the new worksheet. I find it particularly boring to size all the columns, and I just know there must be a simple way around this.
Thanks.

 

[klb]

Make a copy of your worksheet in a new workbook.

Remove any of the existing data that you don't want in your template.

Save the "new" workbook as a template.

Good luck