Excel – Missing Paste special options in Excel 2010

microsoft excelmicrosoft-excel-2010

In Excel, every time I copy and paste, only the text is copying and the formatting is not being copied as shown in the figure below:

screenshot_1

There are no paste special options available while pasting.

In the figure above, I have copied cell A1 using CTRL+C and pasted in cell A3 using CTRL+V. Only the text is pasted and the formatting was not.

This is what I have tried without any 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 screenshot below, only Text and Unicode options were available.

screenshot_2

Best Answer

First, try to run in safe mode : Excel.exe /Safe (in the run command) if that works correctly there, that means that it's due to either an add-in or a workbook that is loaded at startup.

(File>Options > Addins - uncheck all Addins) Note which ones were selected. Close Excel and then reopen it

If that works, then one of the addins was the issue, just have to find which one by reenabling them one by one.

If this didn't work, then it's probably due to one file located in the startup directory of excel. (ie C:\Program Files\Microsoft Office\Office14\XLSTART for me)

Any file in there is loaded when you start Excel. Remove the files out of that folder and open Excel to see if the problem is gone.

if that works, add them back one at a time, closing and reopening Excel each time until you determine which file was corrupted.

Related Question