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:
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:
- Repaired MS Office with LIVE CD.
- Checked the format cells.
- 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.
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.