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?
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.
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 againHi 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.