Enter, Edit, and Delete Data

Basic formatting in Excel XP can customize the look and feel of your Excel XP spreadsheet. Learn about formatting cells in Excel XP here.

Using the Undo and Redo features

Sometimes you might do something to a spreadsheet that you didn't mean to, like type the wrong number in a cell. Excel XP allows you to undo an operation. Use the Undo button Undo button on the Standard toolbar to recover an error. The last single action is recoverable.

To undo recent actions one at a time:

  • Click the Undo button Undo button.

To undo several recent actions at once:

  • Click the arrow next to the Undo button.
  • Select the desired Undo operation(s) from the list.

    The Undo List Box
  • Microsoft Excel reverses the selected action and all actions that appear in the list above it.

An Undo operation can be canceled by applying a Redo. This is useful when an Undo operation was mistakenly applied. Remember, a redo is possible only if you have not changed an Excel spreadsheet since the last Undo operation was completed:

To redo an Undo operation:

  • Press the Redo button Redo button.

To redo several recent Undo actions at once:

  • Click the arrow next to Redo button.
  • Select the desired Redo operation from the list.
  • Microsoft Excel reverses the Undo operation.