课程: Excel Essential Training (Microsoft 365)

Using Undo and Redo

课程: Excel Essential Training (Microsoft 365)

开始一个月试用

Using Undo and Redo

“

- [Instructor] We all make mistakes, and as we work with Excel, sometimes we make a mistake. Sometimes it's drastic, we've deleted a lot of data we didn't mean to. And just a simple little example here. I'm highlighting by holding down the left mouse button, these entries here. Maybe I'm about to make them bold, but then it occurs to me I might want a whole new row above this to separate the months from this. And on my keyboard, insert and delete are right next to each other. I mean to press insert, I'm not even sure if that's the key I want, but maybe I mean to press insert, I hit delete instead, the data's gone. Obviously I don't want to be retyping all those. We can undo our last action with a great keystroke shortcut, Control + Z. And by the way, when you do see keystroke shortcuts listed, sometimes you'll see them at websites or on printed page. They're often written this way and this does not mean to use the plus key. It means hold down the Control key and with it held down, press the letter Z as I did here. Now, you're likely to have a similar button available and what we call the quick access toolbar, typically at the top of the screen. You might or might not have this button here. If you don't have it, and its companion, the redo button here, which we'll be talking about, there is a button to the right right here called customized quick access toolbar. Click this drop arrow here and choose undo. I do recommend both of these present. On many systems, these are set up anyway. So one more time, I'll make the same mistake. I press delete by mistake. This time I'll use that undo arrow there. So whatever's more convenient, undo or Control + Z, it's going to be helpful. Now, sometimes you might be experimenting with visuals or maybe even with numbers where you make a change. It has impact on a formula and you undo it because you're not quite sure you want to make that change. Now, we don't have any formulas here just yet but I'm going to change that to 125. I find out later that was a mistake. If I haven't done anything else in the meantime, I can press Control + Z but then I found out I got wrong information. You can undo the undo, and I know that sounds a bit strange, by pressing Control + Y, that means redo. And if you use undo with the arrow, as I'm about to do at the top of the screen, whatever you undo immediately falls into the category of redo. And often as you click the little tiny arrow to the right, you'll get a description of what you were doing. And I know at times it can be confusing. You can actually undo many, many actions in Excel and let's hope that doesn't happen too often. But those are vital tools and as you work with Excel, from time to time, undo, more often used than redo, undo and its keystroke shortcut Control + Z are handy to have available and real-life savers at times.

内容