Timeline for Issue in Excel: Copy a cell with formula - pastes value of the copied cell
Current License: CC BY-SA 3.0
19 events
| when toggle format | what | by | license | comment | |
|---|---|---|---|---|---|
| Mar 20, 2017 at 10:17 | history | edited | CommunityBot |
replaced http://superuser.com/ with https://superuser.com/
|
|
| Feb 2, 2017 at 9:16 | answer | added | Tim | timeline score: 0 | |
| Feb 7, 2013 at 22:13 | answer | added | dnigmig | timeline score: 2 | |
| Feb 5, 2013 at 13:05 | history | tweeted | twitter.com/#!/StackSuper_User/status/298779261307854850 | ||
| Jan 25, 2013 at 0:42 | comment | added | Scott - Слава Україні | I presume you can (1) click on cell A1, (2) click in the formula bar, or press (F2) to edit in the cell, (3) select the entire contents of the cell, either with the mouse or by typing Ctrl+Home followed by Ctrl+Shift+End, (4) press Ctrl+C to copy the cell, (5) click on cell A2, (6) edit the cell (as in 2), (7) select the contents of the cell (as in 3), and (8) press Ctrl+V to paste. I realize it’s not a viable, long-term solution, but it’s a workaround –– and, if this doesn’t work, your problem may be worse than you realize. | |
| Jan 24, 2013 at 20:36 | comment | added | AD - Stop Putin - | @James That sounds like a good idea! I will try that tomorrow! :) | |
| Jan 24, 2013 at 20:35 | comment | added | AD - Stop Putin - | @pnuts Yes that is right, the clipboard shows "2" - and no, as mentioned there is no Skype on the virtual machine. | |
| Jan 24, 2013 at 20:22 | comment | added | Peter Albert | Could it be that any other program hooks into your clipboard, e.g. to exchange it between your virtual machine and your host? Try to disable it for a test... | |
| Jan 24, 2013 at 16:15 | comment | added | James | Have you tried running Excel in Safe mode? | |
| Jan 24, 2013 at 12:04 | history | edited | AD - Stop Putin - | CC BY-SA 3.0 |
improved formatting
|
| Jan 24, 2013 at 12:02 | comment | added | AD - Stop Putin - | @mcalex Yes, I tried that - in fact (I will bold that), I updated the post in order to mention that the clipboard does not have the formula - just the value! :( | |
| Jan 24, 2013 at 12:00 | comment | added | nixda |
@mcalex Yeah it is. Since he already mentioned this Paste special giving the paste alternatives Text or Unicode I guess he is aware of that option. But I don't know for sure. So lets ask him :)
|
|
| Jan 24, 2013 at 11:16 | comment | added | mcalex | I don't have excel in front of me, but isn't there a 'Paste Special / Formulas' ? | |
| Jan 24, 2013 at 11:03 | comment | added | AD - Stop Putin - | @Tog Added that explanation to the link. Thanks! | |
| Jan 24, 2013 at 11:02 | history | edited | AD - Stop Putin - | CC BY-SA 3.0 |
Emphasized conditions...
|
| Jan 24, 2013 at 10:58 | comment | added | AD - Stop Putin - | @Tog Hi, yes - in the end of the post I described the environment. There is no Skype involved here. | |
| Jan 24, 2013 at 10:56 | history | edited | AD - Stop Putin - | CC BY-SA 3.0 |
Fixed the display..
|
| Jan 24, 2013 at 10:55 | comment | added | Tog | Just to clarify, you say the question you link to is similar, did you try the solution to it or do you not have the Skype add-in. | |
| Jan 24, 2013 at 10:48 | history | asked | AD - Stop Putin - | CC BY-SA 3.0 |