Undo the last action This shortcut is a very basic but extremely useful shortcut. Have you ever been working on something and accidentally pressed the wrong key, erasing everything in a split second? After this brief tutorial you’ll be able to reverse this error in less time than it took to make it. This shortcut relies on an error or mistake to occur.

For this example I am going to have a cell with data in it, which I “accidentally” delete. I have a basic AutoSum formula in the active cell, adding up 55 + 77. Now I “accidentally” press a random key.

My AutoSum formula is replaced with z. Format for both windows an mac. Have no fear!

Repeat the last or previous action with the Repeat command. You can add the Repeat command button into the Quick Access Toolbar for easily repeating the last action by clicking on it directly. Please do as follows. Click the Customize Quick Access Toolbar button on the ribbon, then click More Commands from the drop-down list. See screenshot: 2. Excel for Mac — 2011 or 2008 — doesn’t have a Quick Access Toolbar, but you can customize the Add the Repeat Icon to the Standard Toolbar. Right-click the toolbar and select Customize Toolbars It will be grayed-out if the current command can’t be repeated. After there’s been an Undo action, the.

This is where our shortcut comes in handy. With a simple 2 key shortcut, “command” + “Z”, the cell will be reverted back to its previous state. ⌘Z And the AutoSum formula is back without any questions! This shortcut is extremely useful when you are zooming through a Microsoft Excel spreadsheet and have no time to take your hands off the keyboard.

It is useful even in a casual environment when the shortcut is simply easier than finding the Undo button in the toolbar. Whatever your application for the shortcut is, I have no doubt you will be using it often.

* By submitting your email address, you consent to receive email messages (including discounts and newsletters) regarding Corporate Finance Institute and its products and services and other matters (including the products and services of Corporate Finance Institute’s affiliates and other organizations). You may withdraw your consent at any time. This request for consent is made by Corporate Finance Institute, 16th Floor, 595 Burrard Street, Vancouver, British Columbia. Please to view CFI’s privacy policy.

This iframe contains the logic required to handle Ajax powered Gravity Forms. * By submitting your email address, you consent to receive email messages (including discounts and newsletters) regarding Corporate Finance Institute and its products and services and other matters (including the products and services of Corporate Finance Institute’s affiliates and other organizations). You may withdraw your consent at any time. This request for consent is made by Corporate Finance Institute, 16th Floor, 595 Burrard Street, Vancouver, British Columbia. Please to view CFI’s privacy policy.