Excel 2007 Paste Issue

July 5, 2009 at 18:35:46
Specs: Windows XP

For some reason i cannot copy and paste in excel 2007.

What i am trying to do is, copy a cell with numbers and paste it in another.

The error i am gettin is, when i copy the value and go to the sheet i want to paste it in, i type = and try to paste the value but it wont paste it at all, however i can click on another cell and it will add the location of that cell (e.g. C15 or A21) depending on which cell i click.

I dont want it to do this, it should paste the value i am copying.

Does anyone know what i can do to resolve this issue.

Any help would be greatly appreciated.


See More: Excel 2007 Paste Issue

Report •

July 5, 2009 at 20:01:38
Why are you trying to copy a cell with numbers and paste it after an = sign? Cells with numbers don't require an equal sign.

Besides, I don't think you have an issue to resolve, because I don't think you can do what I think are trying.

If you are clicking the cell and simply copying it, you can't paste it after an = sign. When you copy a cell you are copying every thing Excel knows about that cell, including it's formatting, it's address, etc. You can't paste all that info after an = sign.

However, if you click the cell, and highlight what's in the formula bar, or double click the cell and highlight its contents, then you can paste the "text" that you copied any where you want.

Report •
Related Solutions

Ask Question