word-excel-access-help.com logo
Excel for Dummies
Home
Word 2007
Excel 2007
Access 2007
Word xp
Excel xp
Access xp

Excel for Dummies
Additional Resources



Excel for Dummies


Excel for Dummies

Excel for Dummies - Undo & Redo | Microsoft Excel XP

Microsoft Excel XP logo
Excel for Dummies will teach you step-by-step how to use the undo and redo feature of Excel XP. Don't let other people make you a dummy, let me teach you the easy way.

Excel Office Helper What's on this page...
Undo Changes
Redo your Undo

Excel for Dummies - Undoing Changes and Mistakes

One very useful feature in Excel is its multilevel undo. This might be Excel for dummies, but the way to use Undo is made easy.

This means that you can reverse your recent actions, one step at a time.

For example, if you discover that you have accidentally deleted a range of data several minutes ago, you can use the undo feature to backtrack through your actions until the delete range reappears.

However, with the undo feature you can't ask Excel to undo the (for example) 5th command. Excel has to backtrack through your recent steps to get to the 5th command.

You can undo using several techniques:

To undo using the Menu Command, following these steps:

1. Choose Edit from the menu bar.
   
2. Select Undo.
   
  Notice that following the word "Undo" on the menu bar, is the last command that you've done in your worksheet.

This is also the action that will be undone.


To Undo using the Shortcut keys, follow these steps:

Press CTRL + Z until you arrive at the action that you want to undo.
   
  OR
   
Press CTRL + Backspace until you arrive at the action that you want to undo.


To Undo using the Undo button, follow these steps:

Click the Undo Button from the Standard toolbar, until you arrive at the action that you want to undo.
   
  Excel for Dummies: Undo button Undo button
   
  OR
   
Click the drop-down arrow next to the Undo Button.
   
  This displays a list of your recent actions. Select the actions to which you want to undo to.
   
  Excel for Dummies: Undo Button list
 
See also... Redo your Undo
 
Back to Top
 
Return to Excel XP from Excel for Dummies - Undo & Redo
 
Microsoft Excel XP
- Tips
- Excel Screen Layout
- Navigational Techniques
- Working with Workbooks
- Templates
- Working with Worksheets
- Moving Around
- Move Worksheets
- Copy Worksheets
- Insert & Delete Cells
- Insert & Delete Rows
- Insert & Delete Columns
- Resize Row
- Resize Column
- Editing Data
- Content Color
- Cell Color
- Number Formats
- Fonts
- Alignment
- Text Direction
- Indent Contents
- Merge Cells
- Copy
- Move
- Undo & Redo
- Using Zoom
- Freeze & Unfreeze Titles
- Split Worksheet
- Spreadsheet Data
- AutoFill
- AutoComplete
- Comment
- Find
- Replace
- Spellcheck
- Formulas
- Functions
- Print
- Password
- Sorting
- AutoFilter
- Advanced Filter
- Macros
- Charts
- Charting
- Charting Elements
- Gantt Chart
- PivotTable
- PivotTable Calculations
- PivotTable Layout
- PivotTable Format
- PDF to Excel
- PDF-to-Excel Converter
- Excel to PDF Converter