Microsoft Office Tutorials and References
In Depth Information
Once you’ve gotten the principles of data entry nailed down, you’ll need to learn about
the ways in which you can modify, or edit, the information you’ve posted to their cells.
I’m going to introduce those editing techniques now, because, as someone once said,
“Change is good” (when you need to make a change). And when you’re working with
Excel, it’s easy too.
Changing Your Data
Needless to say, there will be times when you’ll need to make changes to at least some
of the data you’ve posted to your worksheet. For example, you may have made an error
or two, or a data update may be in order. Excel makes editing easy, too, and as usual,
presents you with a couple of options.
First and most simply, you can edit the contents of a cell by simply typing over what’s
already there. If you’ve entered the number 7 and discover you needed a 77 instead, just
select the cell and type 77. Excel overwrites the original number.
However, if you’ve entered a lengthy expression that contains one small error into a cell,
retyping all the contents of the cell for the sake of one correction doesn’t seem terribly
efficient. For example, say you typed ”Now is the time for all good mean ,” but you meant
men . Again, you could retype the whole phrase, but there are less troublesome ways to
get what you want. Here’s a more efficient tack:
Select the cell.
Click in the formula bar, right next to the a you want to remove, as
shown in Figure 3–1.
Figure 3–1. Nobody’s perfect—I didn’t mean “mean.” Note that this correction is being made to the phrase in cell