Forum Discussion
Copy & Paste Issue
Hi Jon,
For my knowledge Excel has no setting to change default Copy/Paste behaviour (in opposite, for example, to Word) - it always transfers values with cell formatting.
Did I understand correctly you use simple Copy/Paste (main icons; or Ctrl+C/Ctrl+V; or Ctrl+Ins/Shift+Ins), without applying Paste Special from supporting submenu (e.g. Ctrl+arrow keys after you pasted the value)?
And you copy/paste within one sheet or between different files?
For instance, I pre-load symbols for wins (W) and losses (L) or run totals (O or U) or abbreviations to represent various teams (NYY for the Yankees, for instance). I have always been able to insert these symbols at will. But I copy them from a centered position in the cell, but as of a couple of days ago, the pasted data comes out in the extreme left position.
Now something I should state, if I copy, or cut something and directly paste it, it's ok (it comes out in the original position. It works properly for one operation.But as soon as I attempt to save it, so that I can use it repeatedly from the clipboard, it goes back to pasting in the left. Very frustrating.
But I really appreciate your taking the time to address my problem. Thanks again
Hi Jon,
Sorry, but i still didn't catch, let me repeat in a bit another wording
1) You have an abbreviation in one cell (NYY), that's the only text in this cell, and this text is placed in the center of the cell
2) You stay on this cell, click Copy, go to another cell, click Paste, your NYY appears centered in this cell. 3) You may repeat that with other cells sequentally (stay on another cell, click Paste, when one more, ...) - NYY will be centered in the cells you pasted it
Correct?
After that you attempt to save - to save what, what exactly do you do here?
- Sergei,
I'll try to explain better. I use many symbols or abbreviations with frequency. So I'll copy ,for instance, NYY to my clipboard. When I first use it, before actually saving it, it repeats in the position (centered) that I copied it. But once I attempt to use it a second time, either from the clipboard, or just by repeat pasting it using the right-click on my mouse, or the paste function in Excel, it comes out off-center, usually to the extreme left in the cell.
I'm not sure if I'm making myself clear, but I hope so.- Sergei,
I realize I didn't quite answer the last part of your response. When I say I'm saving something I'm referring to saving whatever it is to my clipboard, so that I can go back to it whenever I need that particular symbol. Does that make sense?Hi Jon,
Thank you, now i reproduced it. If paste from the clipboard Excel keeps formatting of the text, but ignores cell alignments formatting. Moreover, if paste from the clipboard range of cells, Excel misses empty cells.
What's intresting, if i paste from the same clipboard to Word it keeps formatting correctly
So far i have no idea what's the reason, but will try to investigate. And repeated above if someone else from the community knows.
Jon, one more question - as i remember you said above effect appeared on your machine only recently. If so, do you remember if you installed any updates, or new applications; not necessary related to the office.