Article ID: 2702629
Expand all | Collapse all

If you have Skype installed, please read: Text has incorrect format when using paste in Microsoft Office.

Paste Special can make the task of pasting text go more smoothly by letting you choose which formatting you want to keep (source or destination) or by stripping all the formatting and just pasting the text. If you are having issues with Paste Special, continue on to the resolutions below:


Ensure Paste Special is enabled.

To see if Paste Special is enabled:
  1. Go to: File > Options > Advanced.
  2. Under Cut, copy and paste, ensure Show Paste Options button when content is pasted is checked.

Certain web browsers can conflict with the Paste Special option.

Run Excel in the Safe Mode to see if an Add-in is causing the issue.

Running multiple instances of Excel.


Article ID: 2702629 - Last Review: October 2, 2012 - Revision: 4.0

Give Feedback


Contact us for more help

Contact us for more help
Connect with Answer Desk for expert help.
Get more support from