From the course: Excel 2016: Tips and Tricks

Unlock the full course today

Join today to access over 22,600 courses taught by industry experts or purchase this course individually.

Undo, redo, and repeat with keystrokes

Undo, redo, and repeat with keystrokes

From the course: Excel 2016: Tips and Tricks

Start my 1-month free trial

Undo, redo, and repeat with keystrokes

“

- [Voiceover] A really valuable feature in Excel is your ability to Undo an action. And not just your last action, but possibly actions before that as far back as 100 actions. You can Undo up to 100 of your last actions in Excel. And sometimes you'll change your mind and after having undone an action you might want to Redo it. And these are available by way of keystroke shortcuts. I'm working with a worksheet here called Formulas and I'm about to insert a new column to the left of Column B. So I'll right click Column B and Insert, but I mistakenly choose Delete. It's pretty obvious that's caused big problems in Formulas here. I surely don't want to continue here before I correct this. Ctrl z will Undo the action. Now I certainly don't want to Redo it, but if I press Ctrl y, that will Undo the Undo. In this example here that would not be a good use of it. Now keep in mind you also have an Undo button and a Redo button in your Quick Access Toolbar. So at the top of the screen here if…

Contents