"How To Excel" Mini-Tutorials
by TheExcelAddict.com
"Helping Average Spreadsheet Users Become Local Spreadsheet Experts"

Editing A Range Within A Formula By Dragging


I often see Excel users completely redo a formula because a cell reference within the formula is incorrect. Sometimes this is the best option, especially if it is a simple formula such as a SUM formula for the range immediately above. But when you have a more complex formula that contains several different range references, try the following method to easily correct the error.

  1. With the cell containing the formula selected, identify the incorrect range in the Formula Bar.
  2. Now, down in the worksheet, select the correct range of cells which will replace your selection in the Formula Bar. If necessary, use the scroll bars to move the range you wish to select into view.
  3. Now, down in the worksheet, select the correct range of cells. If necessary, use the scroll bars to move the range you wish to select into view.
  4. When you are satisfied that you have the correct range in your formula, press Enter.
If you make a mistake selecting the range:
  • If you haven't already pressed Enter, press the Esc key to cancel the change.
  • If you have already pressed Enter, select Edit, Undo (CTRL+Z) to undo the change.


Why not print (CTRL+P) this tip and share it with your friends and associates?

Get more time-saving tips just like this one delivered to you by email every week in my FREE newsletter "Spreadsheet Tips From An Excel Addict". Subscribe at the www.TheExcelAddict.com/Newsletter.htm.
You'll be amazed how much time you'll save just by learning a few of these tips.

Copyright 2003 All Rights Reserved by Francis Hayes (The Excel Addict)

If you came to this page from my Excel Mini-Tutorials page, click here to close this window,
otherwise click here and you'll find lots more time-saving Excel tutorials like this one.