Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How do I copy and paste a worksheet and maintain all formatting?
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? |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How do I copy and paste a worksheet and maintain all formatting?
Right-click your sheet, choose Move or copy and mark the checkbox
Create a copy. Per Erik On Tue, 19 Sep 2006 11:38:02 -0700, Jana wrote: 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? |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How do I copy and paste a worksheet and maintain all formatting?
Jana
I would create a Template for just that worksheet so I could InsertWorksheet and get my new sheet with all the formatting, formulas, but no data. To create.........go to FileNew Delete all but one sheet. Format and set that up as you wish. FileSave AsFile TypeMS 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 InsertWorksheet Gord Dibben MS Excel MVP On Tue, 19 Sep 2006 11:38:02 -0700, Jana wrote: 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? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
copy and paste with multiple selections in Microsoft Excel | Excel Discussion (Misc queries) | |||
Copy and Paste Macro for front totals sheet | Excel Discussion (Misc queries) | |||
Why can't a copy and paste columns? | Excel Worksheet Functions | |||
IF WorkSheet1 A1=1 then put value of WS1 B2 in WS2 C3 else donothi | Excel Worksheet Functions |