View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
gitlin gitlin is offline
external usenet poster
 
Posts: 3
Default Copy formulas displaying wrong value

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).