Share via

Excel auto fill/ Flash fill is not working

Anonymous
2022-10-13T19:33:06+00:00

Evert time Try to enter a customer formula. Get an answer for that cell, then when I drag it down to get answers for the second cell that follows the same formula I am getting the wrong answer. It is forcing me to double-tap on the individual "future value" cells, and press return/enter on my mac to get the correct answer. Is there any advice that could enable me to not double tap and enter ever for every different cell and instead work when I just drag it down?

I have the Autofill handle and cell drag and drop enabled

Microsoft 365 and Office | Excel | For education | MacOS

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments
Answer accepted by question author
  1. Bob Jones AKA CyberTaz MVP 430.3K Reputation points
    2022-10-13T21:30:46+00:00

    Have a look at the Calculation group on the right end of the Formulas tab... Be sure that Calculation Options is not set to Manual. The typical option of choice is Automatic.

    If you do want it set to Manual you can use the other tools in that group to calculate individual cells on demand (Calculate Now) or calculate the entire sheet at once (Calculate Sheet).

    2 people found this answer helpful.
    0 comments

0 additional answers

Sort by: Most helpful
Most helpful Newest Oldest