SOLVED
Home

Fill handle and formula settings wrong?

Highlighted
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
Tabs and Dark Mode
cjc2112 in Discussions on
48 Replies
Extentions Synchronization
Deleted in Discussions on
3 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
30 Replies
flashing a white screen while open new tab
Deleted in Discussions on
14 Replies
Security Community Webinars
Valon_Kolica in Security, Privacy & Compliance on
13 Replies