G
Guest
I'm copying formulas in excel, but the value of the original cell I copied
appears in all of the 'pasted' cells. However, when I select one of the
'pasted' cells, the copied formula appears in the formula bar. Therefore,
the formula is in the cell, but displaying the wrong value (the one of the
original 'copied' cell). Only after I double-click the 'pasted' cells
(one-by-one), does the formula update to display the correct value.
Any ideas of how to get rid of this? It started after I accidentally messed
around with 'sticky' keys (appears when hitting the shift key 5 times).
appears in all of the 'pasted' cells. However, when I select one of the
'pasted' cells, the copied formula appears in the formula bar. Therefore,
the formula is in the cell, but displaying the wrong value (the one of the
original 'copied' cell). Only after I double-click the 'pasted' cells
(one-by-one), does the formula update to display the correct value.
Any ideas of how to get rid of this? It started after I accidentally messed
around with 'sticky' keys (appears when hitting the shift key 5 times).