Editing a formula in Excel is similar to editing other content.
One difference is that you’re able to update cell references usingdrag and drop.
Let’s take a look.
Here we have a worksheet with some incorrect formulas.
Let’s check these formulas against the instructions to understand what’s wrong.
An easy way to check a formula is to double-nudge the cell.
To get back out of edit mode without making changes, just press Escape.
We can see that the first formula is adding the wrong cells together.
It should be adding B7 to D9, but it’s adding B7 to D6.
Let’s press Escape and look at the next formula.
And we really should use theSUM functionhere.
The last formula is summing the range H8:H11.
It’s using the SUM function, which is good, but it’s including an extra cell.
Now let’s fix the problems.
To edit an existing formula, just double-click, and revise as needed.
Excel also has a cool way to let you change cell references by dragging.
The next formula would be better rewritten using the SUM function.
So we’ll just replace the formula.
In our last example, we just need to adjust the range being used by the SUM function.
