Text loses formatting when I use Cut, Copy, Paste, Paste Special or Format Painter in Excel

When I copy and paste cells within an Excel spreadsheet, the text I copied loses any formatting. I’ve also noticed that the Formatting Painter doesn’t work at all.

How can I fix this?

Answer
Answer

This can be caused by the Skype Click to Call add-on (version 5.1.0.9560) that is installed into your browser when you install Skype. Version 5.1.0.9560 has been known to cause the following issues:

 

  • You use Copy in Excel, Word or PowerPoint and it only pastes Text. Formatting is lost.
  • You use Cut in Word or PowerPoint and it only pastes Text. Formatting is lost.
  • You use Cut in Excel and it performs a Copy and Paste as Text. The original information remains and the pasted information loses formatting and formulas.
  • When you use the right click menu to Paste, the Paste options are limited to Text.
  • When you attempt to copy formulas in Excel, Excel only pastes the values.
  • When you attempt to click on the Format Painter button in the Ribbon, it does not work.
  • When you attempt to drag and drop cells within Excel, an error message displays "The Clipboard cannot be emptied. Another program might be using the Clipboard."

 

Skype has released a new version of the Click to Call add-on that resolves this issue. You can download the newest version by clicking on the following link and then clicking the Download Now button:

Skype Click to Call

 

For more information, please visit the following KB article:

KB2697462 - Clipboard functionality no longer allows ability to paste formatting in Office Apps

Instead of telling our young people to plan ahead, we should tell them to plan to be surprised.

Was this reply helpful?

Sorry this didn't help.

Great! Thanks for your feedback.

How satisfied are you with this reply?

Thanks for your feedback, it helps us improve the site.

How satisfied are you with this reply?

Thanks for your feedback.

 
 

Question Info


Last updated February 12, 2021 Views 71,709 Applies to: