2
Hi I have a problem with my excel .. I want to paste one bunch of rows to another excel document and I can't do it with simple copy/paste ..
I can copy then paste to notepad then copy again and paste to other file
I have loads of thing to copy .. is there a way arround this ?
user24795
Posted 2010-03-04T15:43:41.460
Reputation: 191
2
Have you changed DDE settings for Excel?
Excel Button -> Excel Options -> Advanced -> Ignore other application that use DDE.
This is often checked to enable multiple instances of Excel, but I have found that doing this can effect how those instances interact with each other (including copy/paste).
mindless.panda
Posted 2010-03-04T15:43:41.460
Reputation: 6 642
2
The Excel files are probably opened in separate instances of Excel. Doing this means losing some of Excel's functionality.
Try opening one file, then open the other by pressing Ctrl + O and navigating to the file.
The copy paste should work then.
guitarthrower
Posted 2010-03-04T15:43:41.460
Reputation: 933
0
Well, this should work fine:
Peter Lang
Posted 2010-03-04T15:43:41.460
Reputation: 107
@Peter Lang tried that m8 not working .. – user24795 – 2010-03-04T16:00:59.177
0
Excel will usually try to preserve formulas, references, etc.
If you just want to copy over the values, you can copy, then from the Edit menu, select Paste Special - you can then select what and how you want to paste the clipboard into the new sheet.
I haven't found a keyboard shortcut for this, unfortunately, nor a way to default the paste to "values only".
chris
Posted 2010-03-04T15:43:41.460
Reputation: 8 607
0
Excel has a peculiar way of handling the clipboard. The clipboard is the temporary place where the copied data goes.
Be sure not to do anything that could clear the clipboard between copying and pasting. It includes:
... and many I'm probably not even aware of. A good indicator of whether or not your data is in the clipboard is the status bar. If it shows "Select destination and press ENTER or choose Paste", then you're good.
raph82
Posted 2010-03-04T15:43:41.460
Reputation: 116
Does not sound programming related, but what happens when you try to copy/paste directly from one document to another? – Peter Lang – 2010-03-04T15:48:01.397
@Peter Lang nothing can't choose paste and can't CTRL + v – user24795 – 2010-03-04T15:48:44.597
So you open both documents, select some cells in the first document, press Ctrl+c, change to the other document and press Ctrl+v, and nothing happens? What happens when you try to paste it somewhere in your first document? – Peter Lang – 2010-03-04T15:51:08.067
@Peter Lang
So you open both documents, select some cells in the first document, press Ctrl+c, change to the other document and press Ctrl+v, and nothing happens?- YES , it pastes just fine when I paste it in first document on into external notepad file. – user24795 – 2010-03-04T15:55:52.457