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 assume I must have inadvertantly hit some setting to change this feature, but I can't find my way back. Can anyone please help?
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?
Dear Jon Hall,
Kindly try pasting as values (Paste Special > Values) and check if your issue gets resolved.
What is the alignment of the cell from which you are copying the data and
the alignment of the cell to which you are pasting the data?
Vijaykumar Shetye,
Spreadsheet Excellence,
Panaji, Goa, India
