Microsoft Office Tutorials and References
In Depth Information
Undoing the Last Cell Entry
Table 1–5 Summary of In-Cell Editing Tasks
Task
Mouse
Keyboard
1
Move the insertion point to the
beginning of data in a cell.
Point to the left of the fi rst character and 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 click.
Press END
3
Move the insertion point
anywhere in a cell.
Point to the appropriate position and click the
character.
Press RIGHT ARROW or
LEFT ARROW
4
Highlight one or more adjacent
characters.
Drag the mouse pointer through adjacent
characters.
Press SHIFT + RIGHT ARROW
or SHIFT + LEFT ARROW
5
Select all data in a cell.
Double-click the cell with the insertion point
in the cell if there are no spaces in the data in
the cell.
6
Delete selected characters.
Click the Cut button on the Home tab on the
Ribbon.
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 command on the Quick Access Toolbar (Figure 1–95),
which allows you to erase recent cell entries. Thus, if you enter incorrect data in a cell and
notice it immediately, click the Undo button and Excel changes the cell entry to what it
was prior to the incorrect data entry.
Redo
button
Undo
button
Undo
button
arrow
Undo list
contains
recent actions
Clear
button
Select All
button
Figure 1–95
Excel remembers the last 100 actions you have completed. Thus, you can undo up to
100 previous actions by clicking the Undo button arrow to display the Undo list and then
clicking the action to be undone (Figure 1–95). 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 dimmed and inoperative.
The Redo button, next to the Undo button on the Quick Access Toolbar, allows you
to repeat previous actions.
 
 
Search JabSto ::




Custom Search