Microsoft Office Tutorials and References
In Depth Information
Renaming a Worksheet
simply clear the value in the cell and then type the correct value. However, sometimes
you need to edit only a portion of an entry rather than change the entire contents of a
cell, especially if the cell contains a large block of text or a complex formula. To edit the
cell contents, you can work in Edit mode .
When you work in Edit mode, some of the keyboard shortcuts you’ve been using work
differently because they apply only to the text within the selected cell. For example, the
Home, End, Backspace, Delete, and arrow keys move the insertion point to different
locations within the cell. The Home key moves the insertion point to the beginning of
the cell’s content. The End key moves the insertion point to the end of the cell’s content.
The left and right arrow keys move the insertion point backward and forward through
the cell’s content. The Backspace key deletes the character immediately to the left of the
insertion point, and the Delete key deletes the character to the right of the insertion point.
You’ll change one digit of the value in cell G6 to correct the price per DVD.
To edit the value in cell G6:
1. Click the Customer Orders sheet tab to make it the active worksheet.
2. Double-click cell . The mode indicator on the status bar switches from Ready to G6
Edit, indicating that you are in Edit mode.
To change the active
cell to Edit mode, press
the F2 key or click in the
formula bar. To cancel
all changes made in Edit
mode, press the Esc key or
click the Cancel button in
the formula bar.
3. Press the End key. The insertion point moves to the end of the cell.
4. Press the
key three times. The insertion point moves to the right of the 7.
5. Press the Backspace key to delete the 7, and then type . The value in cell G6 8
changes to 18.29. See Figure 1-25.
Cell being edited in Edit mode
value being edited
within th e cell
shows t hat Excel
is in Edi t mode
6. Press the Enter key to accept the edit in cell G6. The value $18.29 appears in
cell G6, the active cell is cell G7, and the mode indicator on the status bar changes
from Edit to Ready to indicate that you are no longer in Edit mode.