Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Copy entire Worksheet how?
I create proposals/Bids. Each contains many different
formats, e.g. 3 pages long, some merged cells, different width collumns, Rows, 12 , 14 and 15 pt fonts, bold and italic, etc. For the next bid I want to copy the first one to a new work sheet with all formats preserved. Right now, i need to re-adjust collumn width, sheet/grid, etc. Any suggestions greatly appreciated... |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Copy entire Worksheet how?
Hold the Ctrl key and drag the desired sheet either left or Right. Release
the mouse first, then let go of the Ctrl key. Alternatively, you can Right-Click the sheet you want to copy and use the "Move or Copy..." command, making sure you check "Create a copy". -- _________________________ Robert Rosenberg R-COR Consulting Services Microsoft MVP - Excel http://www.r-cor.com "Stormin' German" wrote in message ... I create proposals/Bids. Each contains many different formats, e.g. 3 pages long, some merged cells, different width collumns, Rows, 12 , 14 and 15 pt fonts, bold and italic, etc. For the next bid I want to copy the first one to a new work sheet with all formats preserved. Right now, i need to re-adjust collumn width, sheet/grid, etc. Any suggestions greatly appreciated... |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Copy entire Worksheet how?
One method....
Right-click on the sheet tab and select "move or copy". Check "create a copy" and decide where you want the copy placed in the workbook then OK. Re-name the copied sheet. *****Another method******* You may wish to investigate the use of a default Template for the new sheet. Open a new workbook and copy the bid worksheet into it. Delete other sheets. Clear the current bid info from the sheet so's all that's left is formulas, formats and any other constants like Titles, etc. FileSave As Type: scroll down to Excel Template(*.XLT) and select. Name your workbook "SHEET"(no quotes). Excel will add the .XLT to save as SHEET.XLT. Store this workbook in the XLSTART folder usually located at........ C:\Documents and Settings\username\Application Data\Microsoft\Excel\XLSTART It now becomes the default InsertSheet. More can be found on this in Help under "templates"(no quotes). Gord Dibben Excel MVP On Tue, 3 Feb 2004 15:15:24 -0800, "Stormin' German" wrote: I create proposals/Bids. Each contains many different formats, e.g. 3 pages long, some merged cells, different width collumns, Rows, 12 , 14 and 15 pt fonts, bold and italic, etc. For the next bid I want to copy the first one to a new work sheet with all formats preserved. Right now, i need to re-adjust collumn width, sheet/grid, etc. Any suggestions greatly appreciated... |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Copy entire row to different worksheet | Excel Worksheet Functions | |||
If statement to copy an entire row to other worksheet w/ in same b | Excel Worksheet Functions | |||
how do I copy an entire worksheet to another with text & format? | Excel Discussion (Misc queries) | |||
Is there a function to copy an entire worksheet? | Excel Worksheet Functions | |||
need a formula to copy entire row to next worksheet | Excel Worksheet Functions |