| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Copying template from one worksheet to another
I have created an inventory worksheet with specific column and row
dimensions, company logo, and formulas. It has 25 lines for individual inventory items. I'm trying to figure out how to copy this worksheet to another worksheet, yet still maintain the format of the original worksheet. I can copy and paste to a new worksheet, but I lose the formatting. The new worksheet appears with the default row and column dimensions, so I have to manually adjust these dimensions for each new worksheet. Is there a way that I can copy my original worksheet to additional worksheets, and still maintain the formatting (cell dimensions, formulas, logo, etc.)? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Copying template from one worksheet to another
Don't just select the cells and copy/paste.
Right-click on the sheet tab and "Move or Copy" Select "create a copy" and OK Gord Dibben MS Excel MVP On Tue, 1 Dec 2009 09:30:01 -0800, Bustyn wrote: I have created an inventory worksheet with specific column and row dimensions, company logo, and formulas. It has 25 lines for individual inventory items. I'm trying to figure out how to copy this worksheet to another worksheet, yet still maintain the format of the original worksheet. I can copy and paste to a new worksheet, but I lose the formatting. The new worksheet appears with the default row and column dimensions, so I have to manually adjust these dimensions for each new worksheet. Is there a way that I can copy my original worksheet to additional worksheets, and still maintain the formatting (cell dimensions, formulas, logo, etc.)? |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Copying template from one worksheet to another
Bless you. Just what I needed. Thank you very much. "Gord Dibben" wrote: Don't just select the cells and copy/paste. Right-click on the sheet tab and "Move or Copy" Select "create a copy" and OK Gord Dibben MS Excel MVP On Tue, 1 Dec 2009 09:30:01 -0800, Bustyn wrote: I have created an inventory worksheet with specific column and row dimensions, company logo, and formulas. It has 25 lines for individual inventory items. I'm trying to figure out how to copy this worksheet to another worksheet, yet still maintain the format of the original worksheet. I can copy and paste to a new worksheet, but I lose the formatting. The new worksheet appears with the default row and column dimensions, so I have to manually adjust these dimensions for each new worksheet. Is there a way that I can copy my original worksheet to additional worksheets, and still maintain the formatting (cell dimensions, formulas, logo, etc.)? . |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Copying a spreadsheet template | New Users to Excel | |||
| Prorammatically copying Chart Component from Excel Template | Excel Discussion (Misc queries) | |||
| Looking up a variable in one worksheet and copying information from another column to another worksheet?? | Excel Discussion (Misc queries) | |||
| Copying Excel template to Word 2003 | Excel Discussion (Misc queries) | |||
| Template question - can I replace the default "worksheet" template | Excel Discussion (Misc queries) | |||
Linear Mode
