05-07-2017 01:24 AM
05-07-2017 01:24 AM
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?
05-07-2017 08:57 AM
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?
Panaji, Goa, India
05-07-2017 10:17 AMSolution
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?
05-08-2017 12:32 AM
05-08-2017 01:56 AM
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?
05-08-2017 08:42 AM
05-08-2017 09:43 AM
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
After that you attempt to save - to save what, what exactly do you do here?
05-09-2017 12:50 AM
05-09-2017 12:55 AM
05-09-2017 04:46 AM
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.
05-09-2017 11:52 PM
No, that's what's so odd. I've been using Excel for yearsand as far as I 'm aware, nothing has changed, as far as updates. But perhaps I missed something. Maybe I'll try to go to a Restore Point.
05-10-2017 03:29 PM
Yes, you may try restore point, if it's not so far you lost practically nothing. Or try to repair your Office, especially if that's O365 - quite safe operation.
Could help, could not. The problem is Office clipboard behaviour depend on not only Office application (Excel in our case) and its settings, but on entire environment of your PC. Office clipboard is directly connected to system clipboard which is used by all other applications.
On forums i've seen cases of wrong Office clipboard behaviour (not exactly as in your cases, but simular ones) due to new version of Skype, or Adobe Flash Player, or some else were installed. That could be due to another Win or Office update. I don't know the reason so far.
Anyway, it's worth to repair/restore if you have such option, that could help. You lost nothing but some time. Just be ready that could not solve the issue and you return back to current situation with next update of your OS/applications.