Microsoft Office Tutorials and References
In Depth Information
Correcting Errors
Table 1– 5 Summary of In-Cell Editing Tasks
Task
Touch / Mouse
Keyboard
1.
Move the insertion point to the
beginning of data in a cell.
Point to the left of the rst
character and tap or click.
Press HOME
2.
Move the insertion point to the
end of data in a cell.
Point to the right of the last
character and tap or click.
Press END
3.
Move the insertion point anywhere
in a cell.
Point to the appropriate position
and tap or click the character.
Press RIGHT ARROW or
LEFT ARROW
4.
Highlight one or more adjacent
characters.
Drag through adjacent characters.
Press SHIFT + RIGHT ARROW
or SHIFT + LEFT ARROW
5.
Select all data in a cell.
Double-tap or double-click the
cell with the insertion point in the
cell if the data in the cell contains
no spaces.
6.
Delete selected characters.
Tap or click the Cut button
(HOME tab Clipboard group). |
Press DELETE
7.
Delete characters to the left of the
insertion point.
Press BACKSPACE
8.
Delete characters to the right of
the insertion point.
Press DELETE
9.
Toggle between Insert and
Overtype modes.
Press INSERT
Undoing the Last Cell Entry
Excel provides the Undo button on the Quick Access Toolbar (Figure 1– 72),
which allows you to erase recent cell entries. Thus, if you enter incorrect data in a cell
and notice it immediately, tap or click the Undo button and Excel changes the cell
entry to what it was prior to the incorrect data entry.
Undo button
Undo list
Select All
button
Figure 1– 72
Excel remembers the last 100 actions you have completed. Thus, you can undo
up to 100 previous actions by tapping or clicking the Undo arrow to display the Undo
list and then tapping or clicking the action to be undone (Figure 1– 72). You can drag
through several actions in the Undo list to undo all of them at once. If no actions
are available for Excel to undo, then the Undo button is unavailable; its dimmed
appearance indicates that it is unavailable.
The Redo button, next to the Undo button on the Quick Access Toolbar, allows
you to repeat previous actions; that is, if you accidentally undo an action, you can use
the Redo button to redo it.
Search JabSto ::




Custom Search