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.