Microsoft Office Tutorials and References
In Depth Information
Editing cell contents
Unlike Undo, Repeat works with most actions. The only exceptions are those actions you
can’t logically repeat. For example, if you save a file by clicking the File tab and then Save,
you can’t repeat the action. Whatever the case, Repeat reflects the last repeatable action.
Editing cell contents
You can use the formula bar to edit the contents of a selected cell, or you can perform your
editing “on location” in the cell. Excel also includes a few special features you can apply to
tasks, such as entering date sequences, which once involved editing each cell but are now
semiautomatic if you know where to find the “trigger.”
Editing in cells or in the formula bar
While typing or editing the contents of a cell, you can use Cut, Copy, Paste, and Clear
to manipulate cell entries. Often, retyping a value or formula is easier, but using
commands is convenient when you’re working with long, complex formulas or with labels.
When you’re working in a cell or in the formula bar, these commands work just as they
do in a word-processing program such as Word. For example, you can copy all or part of
a formula from one cell to another. For example, suppose cell A10 contains the formula
=IF(NPV(.15,A1:A9)>0,A11,A12) and you want to type =NPV(.15,A1:A9) in cell B10.
You can edit the contents of cells without using the formula bar. By double-clicking a
cell, you can perform any formula bar editing procedure directly in the cell.
To do so, select cell A10, and in the formula bar, select the characters you want to copy—in
this case, NPV(.15,A1:A9). Then press Ctrl+C, or click the Copy button (located in the
Clipboard group on the Home tab). Finally, select cell B10, type = to begin a formula, and press
Ctrl+V (or click the Paste button).
Excel does not adjust cell references when you cut, copy, and paste within a cell or in
the formula bar. For information about adjustable references, see “How copying affects
cell references” in Chapter 12.
When you type or edit formulas containing references, Excel gives you visual aids called
range finders to help you audit, as shown in Figure 8-19, where we obviously have a