Home > All Tips > Microsoft Office Tips
Maximum Number of Undos in Office Programs
Anyone who has typed a Word document or entered data in an Excel spreadsheet has made a mistake or two while typing or accidentally deleted some data and so on. Most people know about the undo option that is a part of most Windows based software. Most of the time the undo option is a toolbar button or you can go to the Edit menu option and choose Undo. A quick keyboard shortcut that comes in handy is Ctrl-Z if you don't want to have to take your hands off the keyboard.
All the Office programs let you click on undo to go back to the previous step if you have made a mistake. If you have you wondered how far back you can go then here's the answer. These numbers may vary depending on your version of Office.
Outlook - unlimited undos
Word - unlimited undos
Access - 1 undo
Excel - 16 undos
PowerPoint - 150 undos
Publisher - 20 undos
FrontPage - 30 undos
You can change the number of undos in Access and Excel by editing the registry. We don't recocommend this though.
PowerPoint is set to 20 undos by default but you can change it if you like. It is not recommended that you increase it too much because it may cause problems in PowerPoint. Go to Tools, Options, Edit tab, and from there you can change the Maximum number of undos up to 150.
Office Tips and Tricks