Microsoft Office Tutorials and References
In Depth Information
Correcting Errors
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 i 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
Excel Help
At any time while using
Excel, you can i nd answers
to questions and display
information about various
topics through Excel Help.
Used properly, this form
of assistance can increase
your productivity and
reduce your frustrations
by minimizing the time
you spend learning how to
use Excel. For instruction
about Excel Help and
exercises that will help you
gain coni dence in using it,
read the Ofi ce 2010 and
Windows 7 chapter at the
beginning of this topic.
Press RIGHT ARROW or
LEFT ARROW
3
Move the insertion point anywhere
in a cell.
Point to the appropriate position and
click the character.
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 (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 command on the Quick Access Toolbar (Figure 1– 75),
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– 75
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– 75). 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