How do I copy and paste a worksheet and maintain all formatting?

[Guest]

I have formatted one worksheet to use weekly. Everytime I copy and paste it
for a new week, I lose some of the formatting. How can I maintain every
change that has been made so I can copy and begin data entry without
reformatting?

 

[Per Erik Midtrød]

Right-click your sheet, choose Move or copy and mark the checkbox
Create a copy.

Per Erik

 

[Per Erik Midtrød]

Right-click your sheet, choose Move or copy and mark the checkbox
Create a copy.

Per Erik

 

[Gord Dibben]

Jana

I would create a Template for just that worksheet so I could Insert>Worksheet
and get my new sheet with all the formatting, formulas, but no data.

To create.........go to File>New

Delete all but one sheet.

Format and set that up as you wish.

File>Save As>File Type>MS Excel Template(*.xlt)

Enter SHEET for the name......let Excel add the .xlt

Store it in your XLSTART folder usually found at

C:\Documents and Settings\username\Application Data\Microsoft\Excel\XLSTART

This will be the default Insert>Worksheet


Gord Dibben MS Excel MVP

 

[Gord Dibben]

Jana

I would create a Template for just that worksheet so I could Insert>Worksheet
and get my new sheet with all the formatting, formulas, but no data.

To create.........go to File>New

Delete all but one sheet.

Format and set that up as you wish.

File>Save As>File Type>MS Excel Template(*.xlt)

Enter SHEET for the name......let Excel add the .xlt

Store it in your XLSTART folder usually found at

C:\Documents and Settings\username\Application Data\Microsoft\Excel\XLSTART

This will be the default Insert>Worksheet


Gord Dibben MS Excel MVP