Formula Readjustment

  • Updated

Like with other spreadsheet software, Spreadsheet.com Formulas use cell references that can sometimes require readjustment. Sometimes you create a formula referring to the value in cell A1 but that value moves to a new cell.

Situations that should not require formula readjustment

Most changes to your worksheet should not require a readjustment; Spreadsheet.com will automatically adjust cell references in formulas for you. Specifically, you should not have to adjust your formulas when:

Situations that may require formula readjustment

  • If your formula uses absolute references that move or change.
  • Copying or cutting data from one place in a worksheet to another.
  • Manually deleting and typing data into a new location.

How to readjust a formula

It is often easiest to readjust the formula in one location, then paste that readjusted formula in all other formula locations. 

For instance, in the animation below we first insert a new column, which does not require us to adjust our formulas. But it does move a fixed value from where we want it to appear. So we move this value, adjust a referring formula, and then paste that new formula in all other locations.

Adjust_Formula_Reference.gif

For more on formulas check out our Formula articles or articles on advanced formatting with formulas.