trouble in copy pasting

  • Thread starter Thread starter Suri
  • Start date Start date
S

Suri

HI,

I was trying to copy the formula in one cell toanother.
Eg: Copy formula "=T157*H157" in cell c5 in to cell C6.

When i drag the formula from cell C5 to C 6 it copy paste as a value. not as
a formula. Didnt have this problem until today. How can i fix this?
Can anyone please help.

Kind Regards,
Suri
 
Is it possible that the worksheet is protected and you are copying from a
locked cell?
 
No. i created the worksheet. And worked on it yesterday. But today i cant
drag the formula in the above cell to below cells. Is it possible t hat i
cahnge the cell format or something...
 
Hi Barb,

Just figured it out. I have selected in data>Options>Calculation as manual
insted of automatic. When i click automatic everything came back to normal.
 
Back
Top