Skip to main content
  • Login
Cart
Exceljet logo Exceljet
  • Training
  • Videos
  • Functions
  • Formulas
  • Shortcuts
  • Articles
Cart
  • Login
  • Training
  • Videos
  • Functions
  • Formulas
  • Shortcuts
  • Articles
  • Login

You are here

Home › Videos › How to edit a formula

How to edit a formula

Transcript 

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.

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.

Master Excel with practice. Download this worksheet (and dozens more) in our Core Excel course. Learn by doing.

Dave Bruns Profile Picture

Author

Dave Bruns

Hi - I'm Dave Bruns, and I run Exceljet with my wife, Lisa. Our goal is to help you work faster in Excel. We create short videos, and clear examples of formulas, functions, pivot tables, conditional formatting, and charts.

Microsoft Most Valuable Professional Award  

Exceljet Training

  • Excel 101
  • Excel Fundamentals
  • Conditional Formatting
  • Essential Formulas
  • Advanced Formulas
  • Pivot Tables
  • Excel Tables
  • Excel Shortcuts
  • Excel Charts
  • Course Bundles
Answers to everyday challenges re excel are easily explained & found on your site. Much appreciated from Cape Town, South Africa
Jacques
More Testimonials

Get Training

Quick, clean, and to the point training

Learn Excel with high quality video training. Our videos are quick, clean, and to the point, so you can learn Excel in less time, and easily review key topics when needed. Each video comes with its own practice worksheet.

View Paid Training & Bundles
Excel foundational video course
Excel Pivot Table video training course
Excel formulas and functions video training course
Excel Charts video training course
Video training for Excel Tables
Dynamic Array Formulas
Exceljet logo Exceljet
Quick, clean, and to the point

Resources

  • Training
  • Videos
  • Functions
  • Formulas
  • Shortcuts
  • Articles

About Us

  • About
  • Testimonials
  • Topics
  • Contact
  • Donate

Newsletter Sign-up

Work faster in Excel. Join more than 100,000 people who get weekly tips from us.
© 2012-2025 Exceljet. Terms of use
  • Visit our Twitter page