Microsoft Office Tutorials and References
In Depth Information
Editing a Worksheet
Using Undo and Redo
If you make a change and then determine you really
didn’t want to make that change, Excel provides an
Undo feature. You can use Undo to restore text that
you deleted, delete text you just typed, or reverse a
recently taken action. An exception to the Undo
function is that if you save your worksheet, you
cannot “unsave” it. Also, if you close the worksheet, you
cannot undo changes made in the previous editing
session when you reopen the worksheet.
To undo any actions or correct any mistakes you
make when entering data, perform one of the
Choose Undo from the Quick Access
Select the steps you want to reverse.
To undo several steps at once, click the
arrow on the Undo button and select the
step from which you want to begin the
Undo action (see Figure 8-13).
Occasionally you need to insert a column, row, or a
single cell in the middle of existing information.
Inserting columns, rows, or cells moves existing
data to make room for new rows or columns.
To repeat your last action, click the Redo button on
the Quick Access Toolbar or press Ctrl+Y.
You can insert a column or row anywhere you need
it by first selecting a cell where you want the new
column or row located. Choose Home>Cells>Insert
(arrow) and choose Insert Sheet Rows or Insert
Sheet Columns. Figure 8-14 illustrates a newly
inserted column C.
There are some actions that Excel cannot