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

J

Jana

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?
 
P

Per Erik Midtrød

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

Per Erik
 
G

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
 
Top