In her regular series for Cambridge Network members, software training expert Karen Roem offers handy tips to help you 'Tame your computer'. This week she describes how to undo several actions in one go (Microsoft Office).
Tame your computer – get back!
The go-back-to-where-I-was-happy (aka Undo) button seems to be well-known among most people. It allows you to reverse one or more operations and restore a document or an e-mail message to its previous state. It is useful when you find that you have accidentally deleted some text or have performed some other operation that has unintentionally modified your document.
But even though the Undo button seems to be the first tool anyone remembers, a lot of people seem unaware you can simultaneously undo or redo a series of operations in Word, Excel, PowerPoint and Access. (Why not in Outlook beats me!)
- Click on the down arrow at the right side of the Undo button. (The button is located on the Quick Access Toolbar.)
- Select the desired actions from the list that you want to reverse.
You can also redo actions that have been undone. Redo is also great for repeating an action. By the way, only in Excel, you can redo several undone actions in one go, similar to the undo action described in this tip.
Oh, and for the keyboard shortcut lovers among us:
- Press and hold the CTRL key and press the Z key to undo an action.
- Press and hold the CTRL key and press the Y key to redo (or repeat) an action.
Finally, some trivia … Apparently, you can do unlimited undos in Word and (individual ones) in Outlook, as well as up to 100 in Excel. By default, you can “only” undo up to 20 actions in PowerPoint, but you can increase that by following the steps as described in this tip.
3 October 2017
Highly respected training company, specialising in Excel, Word, PowerPoint and Outlook. Since 2001 we have successfully developed and delivered training courses for public and private clients, large and small, across 23 countries around the world. We feel passionate about sharing the best of what we know with others and strive to help as many people as we can.