|
cut and paste in excel
hi,
i'm trying to cut and paste from 1 excel worksheet to anotherworksheet. can this be done? |
cut and paste in excel
Have you tried it? What happened?
-- Don Guillett Microsoft MVP Excel SalesAid Software "cj" wrote in message ... hi, i'm trying to cut and paste from 1 excel worksheet to anotherworksheet. can this be done? |
cut and paste in excel
Nothing happens, when i go to the new worksheet it won't let me paste
"Don Guillett" wrote: Have you tried it? What happened? -- Don Guillett Microsoft MVP Excel SalesAid Software "cj" wrote in message ... hi, i'm trying to cut and paste from 1 excel worksheet to anotherworksheet. can this be done? |
cut and paste in excel
return with error: can't paste: data on the clipboard is not the same size
and shape as the selected area. i'm trying to cut and paste between 2 different excel worksheets. i have 2 different worksheets open, i'm not cutting and pasting between 2 different worksheets within the same excel, but 2 different excel programs. "Don Guillett" wrote: The key word here is NEW. Make the new ws before you cut/paste from the old one. -- Don Guillett Microsoft MVP Excel SalesAid Software "cj" wrote in message ... Nothing happens, when i go to the new worksheet it won't let me paste "Don Guillett" wrote: Have you tried it? What happened? -- Don Guillett Microsoft MVP Excel SalesAid Software "cj" wrote in message ... hi, i'm trying to cut and paste from 1 excel worksheet to anotherworksheet. can this be done? |
cut and paste in excel
If you have different instances of XL, you can't copy between them.
I believe that each instance of XL has it's *own* clipboard. Also, that error message comes up when you are trying to copy and paste *merged* cells. If that be the case, UNMERGE them! -- HTH, RD --------------------------------------------------------------------------- Please keep all correspondence within the NewsGroup, so all may benefit ! --------------------------------------------------------------------------- "cj" wrote in message ... return with error: can't paste: data on the clipboard is not the same size and shape as the selected area. i'm trying to cut and paste between 2 different excel worksheets. i have 2 different worksheets open, i'm not cutting and pasting between 2 different worksheets within the same excel, but 2 different excel programs. "Don Guillett" wrote: The key word here is NEW. Make the new ws before you cut/paste from the old one. -- Don Guillett Microsoft MVP Excel SalesAid Software "cj" wrote in message ... Nothing happens, when i go to the new worksheet it won't let me paste "Don Guillett" wrote: Have you tried it? What happened? -- Don Guillett Microsoft MVP Excel SalesAid Software "cj" wrote in message ... hi, i'm trying to cut and paste from 1 excel worksheet to anotherworksheet. can this be done? |
cut and paste in excel
I have never had a problem copying and pasting between different instances
of XL! Are you selecting more than one cell when you're pasting? I agree with RagDyer that unmerging may need to occur. Rob "RagDyer" wrote in message ... If you have different instances of XL, you can't copy between them. I believe that each instance of XL has it's *own* clipboard. Also, that error message comes up when you are trying to copy and paste *merged* cells. If that be the case, UNMERGE them! -- HTH, RD --------------------------------------------------------------------------- Please keep all correspondence within the NewsGroup, so all may benefit ! --------------------------------------------------------------------------- "cj" wrote in message ... return with error: can't paste: data on the clipboard is not the same size and shape as the selected area. i'm trying to cut and paste between 2 different excel worksheets. i have 2 different worksheets open, i'm not cutting and pasting between 2 different worksheets within the same excel, but 2 different excel programs. "Don Guillett" wrote: The key word here is NEW. Make the new ws before you cut/paste from the old one. -- Don Guillett Microsoft MVP Excel SalesAid Software "cj" wrote in message ... Nothing happens, when i go to the new worksheet it won't let me paste "Don Guillett" wrote: Have you tried it? What happened? -- Don Guillett Microsoft MVP Excel SalesAid Software "cj" wrote in message ... hi, i'm trying to cut and paste from 1 excel worksheet to anotherworksheet. can this be done? |
cut and paste in excel
RD
You can copy between instances but only as values and the Paste Special dialog is much different and only allows pasting as Object and other formats. I do agree with the "merged cells" hypothesis. Gord On Fri, 7 Dec 2007 16:29:23 -0800, "RagDyer" wrote: If you have different instances of XL, you can't copy between them. I believe that each instance of XL has it's *own* clipboard. Also, that error message comes up when you are trying to copy and paste *merged* cells. If that be the case, UNMERGE them! |
cut and paste in excel
It is always thoughtful to tell us the WHOLE story in the beginning. -- Don Guillett Microsoft MVP Excel SalesAid Software "cj" wrote in message ... return with error: can't paste: data on the clipboard is not the same size and shape as the selected area. i'm trying to cut and paste between 2 different excel worksheets. i have 2 different worksheets open, i'm not cutting and pasting between 2 different worksheets within the same excel, but 2 different excel programs. "Don Guillett" wrote: The key word here is NEW. Make the new ws before you cut/paste from the old one. -- Don Guillett Microsoft MVP Excel SalesAid Software "cj" wrote in message ... Nothing happens, when i go to the new worksheet it won't let me paste "Don Guillett" wrote: Have you tried it? What happened? -- Don Guillett Microsoft MVP Excel SalesAid Software "cj" wrote in message ... hi, i'm trying to cut and paste from 1 excel worksheet to anotherworksheet. can this be done? |
cut and paste in excel
I seldom if ever use different instances but could swear that I found
pasting between instances impossible. However, you guys are right and I'm wrong. It works on every version I've got, so I guess I use my old, standby excuse .... I'm old and my memory is failing. I guess that's one of the perks of old age. Blame it on the years and not on your stupidity!<bg -- Regards, RD --------------------------------------------------------------------------- Please keep all correspondence within the NewsGroup, so all may benefit ! --------------------------------------------------------------------------- "Gord Dibben" <gorddibbATshawDOTca wrote in message ... RD You can copy between instances but only as values and the Paste Special dialog is much different and only allows pasting as Object and other formats. I do agree with the "merged cells" hypothesis. Gord On Fri, 7 Dec 2007 16:29:23 -0800, "RagDyer" wrote: If you have different instances of XL, you can't copy between them. I believe that each instance of XL has it's *own* clipboard. Also, that error message comes up when you are trying to copy and paste *merged* cells. If that be the case, UNMERGE them! |
| All times are GMT +1. The time now is 09:02 PM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com