Microsoft Office Tutorials and References
In Depth Information
Table 1– 5 Summary of In-Cell Editing Tasks
Move the insertion point to the
beginning of data in a cell.
Point to the left of the i rst character
Move the insertion point to the end
of data in a cell.
Point to the right of the last character
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
Move the insertion point anywhere
in a cell.
Point to the appropriate position and
click the character.
Highlight one or more adjacent
Drag the mouse pointer through
Press SHIFT + RIGHT
ARROW or SHIFT + LEFT
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.
Delete selected characters.
Click the Cut button (Home tab |
Delete characters to the left of the
Delete characters to the right of the
Toggle between Insert and
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.
Undo list contains
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.