One of the most used productivity software is Excel. It has always been that way if you are a Data person. Whenever I talk with customers who use reporting or are part of finance operations, their first choice for data manipulation defaults to Excel. There is familiarity of use, predictable and known UI, ease of formula use and many more. So in this blog, let me try to see how much we know of our tool that we use day-in-day-out a.k.a Excel. I have been writing about various Excel tips over my blog and a lot of times people ask some interesting trivia’s that I get to learn from. This post here is inspired by one such question that did come my way and I am happy to share with you.
If I were to ask – “What is the most commonly used shortcut when you are working with Office?”. What is your answer to this question? There are a number of shortcuts, but the survival of all the computer professionals will go for a toss if today’s keyboards missed “CTRL+C” and “CTRL+V”. This is one such shortcut without which our kid’s homework will be complete, our college assignments would become incomplete, and the code that we write would be incomplete and so on. Hands-down this is one of the most commonly used shortcut we would have used in almost any Office product suite – let alone Excel. Lesser known are thousands more shortcuts like these that we can use. In exploration to one such shortcut is our quiz used in later part of this post.
So if that was not the quiz, what is the quiz or tip all about anyways? The question now to you is, what are the ways you Undo the operations that you have done inside Excel. There are multiple answers:
Option 1: CTRL+Z
The most widely used shortcut to undo the series of operations is the CTRL+Z key. So we have given you one of the common answers.
Option 2: Using Quick Access Toolbar
This is one of those hidden or must say the second most used method of performing the Undo operation. Very powerful because the dropdown in that arrow shows a history and we can undo to a point in time of our document. This is more than powerful than you think.
The quiz question is simple. Can you get me a 3rd Option to do the Undo operation inside Excel? This needs to be repeatable just like our CTRL+Z and I must be able to use this shortcut / operation / click and achieve the same result?