UNDO and REDO in Excel
Very important commands in Excel when working, especially if you're exhausted longer work and concentration to drop us when we begin to work out the bugs, the Undo and Redo commands. These two commands 'Undo' and 'Redo' save our spreadsheet of possible faults or accidental deletion of data in the cell. On the Quick Access Toolbar are two buttons, Undo and Redo button. If you do not see on your toolbar, then add them using the instructions in this tutorial.
After using VBA macros you do not have the possibility to use the UNDO button.
Microsoft Excel program (depending on the Excel version) in its history keeps a certain number of steps backward that we can undo. In some cases it's 16 steps as in Excel 2003. At the end of this tutorial, see how to increase the number of steps in the Undo button. But I think that Excel 2013 has a sufficient number of levels back to the average user Excel.
UNDO command reverses our last action or returns us step back and repeatedly use this command to return all the more backward steps or levels.
If we understand that we made a mistake (accidentally delete part of the text, formula, or data in a cell, etc.), click on the Undo command, which will correct the error. Undo command can be used multiple times in a row, depending on the number of errors and how to step back in editing the document we want to go back.
How to Use the Undo and Redo commands
Use the Undo command that we repeat what we have been doing more steps backward or cancel Redo command. Redo command can be activated as many times repeatedly, depending on how many times we use the Undo command.
Undo and Redo commands can be run as follows:
- Clicking on the buttons to the Quick Access Toolbar (graphical buttons i.e. semicircular arrows to the left and semicircular right)
- Use the key combination Ctrl+Z (Undo) => (Alt+Backspace) or Ctrl+Y (Redo)
Undo and Redo commands can be used as long as the open workbook whatever we save the workbook or not, it is important that you close these commands remain active. After recording workbooks these commands have lost their function in relation to prior history of working in the respective workbook. Each new step (change) will allow the use of the Undo command.
Undo and Redo commands can be added or removed from the Quick Access Toolbar in two ways. One way you see in the picture below and the other way is via the Customize Quick Access Toolbar (see link).
If you are working with a Pivot Table then some adjustments related to the Undo button, you can set in the Advanced Excel Options.
How to increase the number of steps or levels back in Excel 2013
You can use Registry Editor.
Make sure you do well in the Registry Editor.
If you a mistake you can do damage to your computer. Excel 2007 has 100 Undo back level and therefore I think it has and Excel 2013 I have not tried to count but I believe that is so.
If you really want to, first you need to
backup your registry (see video)!
- Close all programs on your computer
- Click Start => Run, type regedit and click OK.
- In the Registry Editor expand the following registry keys:
Microsoft Office Excel 2013
- In the Edit menu, click to create a new command then click New DWORD Value. Please select New Value and type the command name 'UndoHistory' and press the Enter key
- On the Edit menu, click Modify
- For DWORD Value dialog box, click Decimal in the Base area. Enter a value between 0 and 100 in the Value box, click OK, then exit the Registry Editor. (Do not enter a number greater than 100)
- Start Excel
- Try number of Undo levels backwards.