Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
copy worksheet
Hello
I have a workbook which contains several worksheets, all identical (except for their input data). When I create (insert) a new worksheet I can copy & paste cells from an existing sheet into the new one. This is fine, except that the column widths & row heights dont come out right. I can get over this OK, but is there a way to copy an old sheet into a new one and preserve the rows & columns? Thanks K |
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
copy worksheet
Hi KRK
You must copy the complete columns or use this also when you paste your range Rightclick on the destination cell Choose Paste Special Columnwidth OK -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "KRK" wrote in message ... Hello I have a workbook which contains several worksheets, all identical (except for their input data). When I create (insert) a new worksheet I can copy & paste cells from an existing sheet into the new one. This is fine, except that the column widths & row heights dont come out right. I can get over this OK, but is there a way to copy an old sheet into a new one and preserve the rows & columns? Thanks K |
#3
Posted to microsoft.public.excel.newusers
|
|||
|
|||
copy worksheet
"KRK" wrote in message
... Hello I have a workbook which contains several worksheets, all identical (except for their input data). When I create (insert) a new worksheet I can copy & paste cells from an existing sheet into the new one. This is fine, except that the column widths & row heights dont come out right. I can get over this OK, but is there a way to copy an old sheet into a new one and preserve the rows & columns? Have you tried right-clicking on the worksheet tab, and choosing Copy? -- Asking a question? Please tell us the version of the application you are asking about, your OS, Service Pack level and the FULL contents of any error message(s) |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Copy Worksheet wont copy objects. | Excel Worksheet Functions | |||
copy graph from a Worksheet based on a field in another Worksheet | Excel Worksheet Functions | |||
Move/Copy or Copy/Insert worksheet? | Excel Discussion (Misc queries) | |||
copy part of a worksheet into a worksheet in the same file/keepi. | Excel Worksheet Functions | |||
Unable to Insert Worksheet/Move and copy worksheet Excel 2003 | Excel Worksheet Functions |