Copying formatting of worksheets

Paulasirius · Apr 26th, 2002, 04:23 AM

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 · Apr 26th, 2002, 06:01 AM

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

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Apr 26th, 2002, 04:23 AM	#1
Paulasirius New Member Join Date: Feb 2002 Location: Eastbourne Posts: 8	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.

Apr 26th, 2002, 06:01 AM	#2
klb Board Regular Join Date: Apr 2002 Location: Minnesota Posts: 821	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