Forum Discussion
Solved
Copy & Paste Issue
I'm not very tech savvy, but I've been using Excel on a daily basis, for many years. All of a sudden, when I copy an item that is centered, it comes out all the way to the left when I paste it. I...
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?
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?
- Thank you both for responding to my problem. Unfortunately, my issue remains unresolved. I tried going to "Paste Special", but as I noted, I’m fairly tech illiterate, and I couldn't find anything that helped.
In answer to the questions, Sergei, I have always simple copied the data that I wished to enter into my spread sheets from one area to another. I never needed any special actions. The original items were copied in the central position of a cell, but suddenly now, no matter what I do, it gets copied in the extreme left position. My actions are related to record-keeping for baseball. I like to keep my own files, and there are numerous things that I keep on my clipboard as they come up with great frequency. Now, when I go to paste a win or loss, a date or a players name, which I have held in reserve on my clipboard, instead of pasting in it’s original position (centered) it comes out all-the-way to the left.
It's not the end of the world. I just have to go back, when I’m done, and re-align my data. But it is annoying, and as I stated, I’ve been using Excel for many years and never had this issue before. Again, thank you for responding.Hi Jon,
Could you please clarify from where are your original data - do you copy/paste them from web or other external source; or you enter them manually?
- I do it manually.
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
