Microsoft Office Tutorials and References
In Depth Information
Editing a Worksheet
Using Undo and Redo
Picture yourself concentrating really hard on your
spreadsheet when someone sneaks up behind
you and startles you into clicking on some
unknown command button from the Ribbon.
You don’t have any idea what happened, but you
know that it’s not right. That’s why the Undo
command was created.
If you undo an action and then decide that you
want to restore it after all, choose Redo from the
Quick Access Toolbar, or press Ctrl+Y. Unlike
the Undo command, the Redo command only
restores the last action.
To correct your last mistake, choose Undo
from the Quick Access Toolbar (see Figure
1-18) or press Ctrl+Z.
If you close your worksheet before you
caught your mistake, you cannot use the
Undo command to reverse the error.
Check your work before you close your
To correct several mistakes at once, click
the Undo down arrow and find the action
in the list. Excel will undo all of the
actions above the one you are selecting,
so choose carefully.
Inserting and Deleting Cells
You might find yourself in the position of having
forgotten crucial data for your spreadsheet.
Perhaps you entered January’s data and moved
right onto March without entering data for
February. You can insert a new row or column
between the two existing data sets to correct that
problem. Figure 1-19 demonstrates this situation.
To insert an entire row, select a row
where you want your new row to be.
Choose Home > Cells > Insert (arrow)
and choose Insert Sheet Rows. Excel
inserts a new blank row and shifts the
selected row and all rows below it down
to make room.
Reverse one or more mistakes using
the Undo command.