I have a weird problem with the Excel. Every time I copy and paste only the text is copying and the format is not copying as shown in the below figure. There are no paste special options available while pasting. In the Below figure I have copied A1 cell with ctrl+c and pasted in A3 with Ctrl+v. Here only text is pasted the format was not

These are the following solutions I have tried but no luck
1. Repaired MS Office with LIVE CD.
2. Checked the format cells.
3. Tried by closing all instances of Excel.

Interestingly when i went to paste special options as shown in the below screenshot only Text and Unicode options were available.

This question came from our site for professional and enthusiast programmers.

1

Do you have any add-ins or anything like that? These could be causing this behaviour. Try opening Excel whilst holding down the Shift Key (to disable add-ins) to see if this makes any difference.
–
creamyeggMar 16 '12 at 11:17

If you're copying from one Excel window to another then they're open in separate instances. If you opened excel twice from the start menu short cut this will happen. Open one file, open the second via the open dialog and try it again.
–
JesseMar 16 '12 at 17:30

I had the same issue and removing (or put it on 'disable') the add-on 'Skype Click to Call' from Skype in the IE-browser under Internet Options and the tab 'Programs' - 'Manage add-ons', it was solved. Seems that the new Skype version is adding this 'add-on'.

The same happens to one of my user. Excel settings are all the same as what other users have but he just can't do the paste special as usual. Found out that it's the IE add-ons that caused the issue as whenever he clicks on a link to open in IE, the Paste Special will stop working right.