Exceljet

Quick, clean, and to the point

How to edit a formula

One thing you'll need to do in Excel is check and edit formulas to keep them in sync with other worksheet changes. Editing a formula in Excel is similar to editing other content. One difference is that you can update cell references using drag 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-click the cell. To get back out of edit mode without making changes, just press Escape (esc).

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.

The next formula is manually adding only the first three cells in the range F7:F10, so it's missing F10. And we really should use the SUM function here.

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. If we undo our change, and then edit the cell again, we can just drag the reference to D6 onto the cell D9, and press enter. 

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. We can do that by entering edit mode and using one of the highlighted handles to size the range correctly.

Course 

Related shortcuts

Author 
Dave Bruns

Download 200+ Excel Shortcuts

Get over 200 Excel shortcuts for Windows and Mac in one handy PDF.