I can't copy a formula, it returns the copied cells calculation. .

T

Tommie_45

When I try and copy a formula and paste it to the next row down it returns
the answer from the copied cell. I can't seem to copy and paste formulas.
There are no abosolute cell references, it's just a quick addition formula,
but I can't copy and paste it all the way down a column and have it return
the correct answer.
 
M

Manish Bajpai

Please click on "Tools", "Options","Calculation" and
change the settings from Manual to automatic.

Regards,

Manish
 

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

Similar Threads

Copy addition formula of non-consecutive horizontal cells 2
Excel help needed: Skipping cell without skipping cell reference 1
VB Script reference cells for in current table? 1
Copy corresponding cell in Column B if cell in A contains certain text? 1
return multiple values when within range (greater than and less than) 11
Merging from an Excel file with graphics 1
Visio shape text disappears upon copy paste 1
Time Sum in Excel 1

Top