B
Bob
I have Excel 2007 SP2. When I try to copy a formula using Ctrl+C and
paste using Ctrl+V, only the copied value (i.e., not the calculated
value using the formula) is pasted. When I copy using Ctrl+C and paste
using a right mouse click, it pastes correctly. Also, if I copy using
Ctrl+C and drag to the cells I want to calculate, it pastes correctly.
If I copy using Ctrl+C in cell C1 (having divided A1 by B1) and then
select cells C2-C3 and try to paste using Ctrl+V, I get a message that
the data on the clipboard is not the same size and shape as the
selected area, do you want to paste the data anyway? I say OK and the
column headings change from letters to numbers!
I've tried rebooting, repair, reinstallation of Excel, all to no
avail. Any ideas what's going on here?
paste using Ctrl+V, only the copied value (i.e., not the calculated
value using the formula) is pasted. When I copy using Ctrl+C and paste
using a right mouse click, it pastes correctly. Also, if I copy using
Ctrl+C and drag to the cells I want to calculate, it pastes correctly.
If I copy using Ctrl+C in cell C1 (having divided A1 by B1) and then
select cells C2-C3 and try to paste using Ctrl+V, I get a message that
the data on the clipboard is not the same size and shape as the
selected area, do you want to paste the data anyway? I say OK and the
column headings change from letters to numbers!
I've tried rebooting, repair, reinstallation of Excel, all to no
avail. Any ideas what's going on here?