trouble in copy pasting

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
 
B

Barb Reinhardt

Is it possible that the worksheet is protected and you are copying from a
locked cell?
 
S

Suri

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

Suri

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top