Forum Discussion

nikitaljaard's avatar
nikitaljaard
Copper Contributor
May 21, 2021

Drag and fill

When I try to drag and fill a SUM formula, i only get the cell value replicated, not the formulae. What am I doing wrong?

2 Replies

    • nikitaljaard's avatar
      nikitaljaard
      Copper Contributor
      Hans Vogelaar has answered my question in response to a different post.
      "Make sure that Calculation Options on the Formulas tab of the ribbon is set to Automatic"
      Thanks!

Resources