Excel 2007 : Ctrl v doesn't work correctly

I have Excel 2007 SP2. When I try to copy a formula using Ctrl+C and paste using Ctrl+V, only the copied value 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 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. What gives?

Thanks for following up. I figured it out: I forgot I had a program called AutoHotKey running that removed formatting when using Ctrl+v. Works normally when that program isn't running.

Originally Posted by martindwilson

do they work as expected in word or other applications ? as far as i know there is no short cut(without macro) that will change to r1c1 style whick is what is happening when columns change from letters to numbers without some code in the workbook whick is being activated with ctrl+v