View Single Post
  #1   Report Post  
KC Mao
 
Posts: n/a
Default copy a cell value not its function

Excel question:

ce11 A1 value=500
Cell B1 value=600
Cell C1 value=2000
Cell D1 value=50
Cell E1 value=C1-D1-B1-A1
use contrl+D to copy cell E1 value all the column down to cell E100
What I wnat is to use contrl+D to copy E1 value not its fuction.

Please if someone could help.