Datasheet

130
PART II
■
GETTING THE DATA IN
Editing formulas
You can easily change a formula in any way (function, arithmetic operators,
referenced cells, or constant values, which pretty much covers everything).
To edit a formula, double-click the cell and select and replace whatever
needs changing, as shown in Figure 4.26. Press Enter to finish your edits.
Figure 4.26. You can edit a formula in the cell or in the Formula bar.
Editing a formula is often easier if you click the cell and do your edit-
ing in the Formula bar. Depending on your worksheet font, the formula
in the Formula bar is nearly always easier to read and use your mouse in.
Easy ways to change parts of a formula are as follows:
■
To replace a referenced cell, double-click the reference to select it,
then click the replacement cell in the worksheet.
■
To replace a range, double-click and drag over both references (to
select the whole range), and then drag to select the replacement
range in the worksheet.
■
To replace a constant value or arithmetic operator, select the char-
acter(s) and type a replacement.
Bright Idea
If you want to replace a cell reference with a different cell reference, don’t
type the new reference; instead, double-click the old reference and then click
the new reference cell on the worksheet.
Watch Out!
Be careful not to click other cells unintentionally while a cell is open for edit-
ing, because those unintentional cells are added to your formula. If you inad-
vertently add other cells to your formula, press Esc to back out of the cell
with no changes, and start again.
09_763217 ch04.qxp 1/18/06 11:23 PM Page 130