SOLVED
Home

Fill handle and formula settings wrong?

Dragon_Claw
Occasional Contributor
Lately, my fill handle has gone off the rails. I used to double click on the little arrow and the rest of the column would get the formula.

Now it just copies the data(using the same formula). I don't keep absolute refrences, but the data is "copied", even though the formula and refrences are different.

If I paste with formatting only, it will erase the cell with the data that was just "copied".

It used to work just fine, what's going on?
3 Replies
Also, with the "copied" formula (referencing different cells for data), if I go down the column or row, open the formula, and push enter, it will now display the proper information.
Solution

Check on ribbon if Formulas->Calculation Options is set to Automatic

Yes, this is it! Thanks so much!
Related Conversations
flashing a white screen while open new tab
cntvertex in Discussions on
13 Replies
Tabs and Dark Mode
cjc2112 in Discussions on
22 Replies
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
28 Replies
PacketMon Components are not loading in WAC 1909
HotCakeX in Windows Admin Center on
2 Replies