Datasheet

Adding and Editing Data in a Workbook
15
To the right of the Undo button is a small downward-pointing dropdown
arrow. Click this arrow to open a list of all you’ve done recently, so you can
undo more than one action if necessary.
Exercise 1.5 illustrates ways to edit all or part of the content of a cell.
EXERCISE 1.5
Editing Data in a Worksheet
1. Still inside Exercise 1-1.xls, select cell A9 by clicking it one time. Notice your Status bar
shows “Ready.” When you want to totally change the content of a cell, you do not need
to delete what is in the cell first. Simply type what you want and press Enter, and the con-
tent will be replaced. Type Rosewood and press Enter. Notice that the content has been
changed.
2. Select cell D4. In this case, we don’t want to change the entire contents. Instead, we only
want to change one digit in this number. We want to change 10000.5 to 11000.5. To do this,
we need to move from Ready mode to Edit mode; this can be done in one of three ways:

Double-click any cell and your Status bar shows “Edit.”

Click any cell, then press F2 and your Status bar shows “Edit.”

Click any cell; then click in the Formula bar where you see the cell content below the
Formatting toolbar. Your Status bar shows “Edit.”
3. Once you use one of these three methods to get into Edit mode, in cell D4 you will see an
I beam. This I beam designates the insertion point, which shows where your typing will
be entered within the cell. Use your ← and → keys to move to the right of the number 1,
press the Delete key on your keyboard one time to remove one of the zeroes, and then
type 1.
4. Press Enter and the content of the cell now shows 11000.5.
5. Using the methods described earlier, change the contents of the following cells to these
new values:

Change B6 to 1275.75.

Change A4 to Burberry.

Add 50 to cell D8.
6. Leave this workbook open for the next exercise.
4002book.fm Page 15 Friday, March 24, 2006 11:36 PM