How JustAnswer Works:
  • Ask an Expert
    Experts are full of valuable knowledge and are ready to help with any question. Credentials confirmed by a Fortune 500 verification firm.
  • Get a Professional Answer
    Via email, text message, or notification as you wait on our site.
    Ask follow up questions if you need to.
  • 100% Satisfaction Guarantee
    Rate the answer you receive.
Ask Val B Your Own Question
Val B
Val B, Analyst / Trainer
Category: Microsoft Office
Satisfied Customers: 54
Experience:  Expert in solving Microsoft Office problems.
36150026
Type Your Microsoft Office Question Here...
Val B is online now
A new question is answered every 9 seconds

Excel formula not copying

This answer was rated:

My Excel suddenly started not copying down formulas. It works when you put in a formula either by entering the cell or clicking the cell with the mouse. But the cell will not repeat the result of that formula when copying down to update a column. It also does not update the result if you change the amount in one of the cells in the formula. I was using Excel 97, but just purchased Microsoft Office 2010 and it did the same thing. My old version is still on the computer if that matters. Any suggestions?

Try formatting your cells as "General"

Also please click on File > Options > Formula and check to see if Workbook Calculation is set to Automatic.

Val B and other Microsoft Office Specialists are ready to help you

Related Microsoft Office Questions