Excel Productivity Guide
Useful Excel Tips | Keyboard Shortcuts | VBA Codes
Download this Free E-Book to take your excel skills to a whole next level using some smart Excel tactics.
Worth $20, Absolutely Free
Do you know a normal excel user press Ctrl + Z (undo) & Ctrl + Y (redo), 50 times in a day while working on a spreadsheet?
And, still he/she is always confused that he/she has to press Ctrl + Z (undo) or Ctrl + Y (redo).
Do you know there is a smarter way for Undo & Redo?
And, this smarter way comes from your quick access toolbar.
You can use undo and redo buttons from quick access toolbar which has a list of activities you have done.
And, you can undo or redo to a particular activity by using these buttons.
When you activate quick access toolbar in excel, it will have the undo & redo buttons by default.
And, if you don’t have, please follow these simple steps to activate them.
Now, you have two buttons in your quick access toolbar.
Just click on the undo or redo button to get the list of recent activities.
Now, you don’t have to use shortcut again & again to come back to an action in your spreadsheet.
Just select the action at which you want to go.
By using this technique you don’t have to press ctrl + z & Ctrl + Y again and again.
You just have to select the activity up to where you want to undo or redo from the list and you will be there with a single click.
I hope you found this quick tip useful.
Please share your views in the comment box.
Here I have some lite weight quick tips for you.