"How To Excel" Mini-Tutorials|
"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.
If you make a mistake selecting the range:
- With the cell containing the formula selected, identify the
incorrect range in the Formula Bar.
- 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.
- 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.
- When you are satisfied that you have the correct range in your
formula, press Enter.
- 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)