To undo your last action, press control+z; to undo the action before that, press control+z again; press control+z repeatedly to undo as many as 100 of your last actions. Sometimes, after undoing ng an action, you might want to reconsider and "undo the undo" (redo) - press control+y. Also use control+y to repeat an action.
- [Voiceover] We're looking at a worksheet called Undo Redo, and that describes two features that you want to be familiar with. There will be times in Excel you just make a mistake. What if I'm a relatively new user of Excel, and I want to get rid of the data in row five. Now, I can right-click row five and delete. That probably isn't what I want. And maybe at first I'm not sure, but as soon as I see what's happening on the screen I know I've made a mistake here, I want to undo this. I'll press Command + Z or Ctrl + Z, and that takes back my last action. Now possibly I did something before this that I want to undo as well.
The undo feature allows you to undo up to 100 of your last actions, and that's highly unlikely. At times maybe undo your last two or three actions. Now I've been doing other things with this worksheet and other worksheets, so in the Quick Access toolbar you'll see a button for undo. It's a counter-clockwise arrow, and a little drop arrow to the right of it. So here are some of the recent things I've been doing. Some of these are a little vague, Format Cells could be anything from bold, italic, font color, font size, changes like that, some of them are a bit more obvious like Row Height, Column Width, that sort of thing, but if I wanted to undo my last five actions, my last seven actions, that's fine, I can undo a whole series of these by sliding over them and then clicking to undo those actions.
You cannot go back and undo, for example, your third last action and your fifth last action without also undoing the fourth last action. You can undo only a consecutive set, but that's gonna be handy at times. Now there will be times when you make a choice, see what this chart over here, you might or might not be familiar with how to work with charts, but as I look at this chart right now, I'm saying well I think I like the look of that, but I'm going to go to the Chart Design tab in the ribbon, a tab that appears when a chart is selected, and off to the right I'm going to change the chart type to a line chart.
And as I look at this, I'm thinking well that looks pretty good. Do I like it better than the chart that I just saw earlier, the column chart? I might press Command + Z to undo, and I like that too, but I want to go back to the line chart again. If you want to undo the undo, that's called redo, and that's Command + Y. The Command + Z undo, Command + Y redo. And whether you call it redo, or undo the undo, same thing. Occasionally trying to explain this to others you get a little tangled in your own words.
But there will be times when you say I want to undo the last action that I took, Ctrl + Z, or undo the undo, Ctrl + Y. It can get confusing at times. You can also use Ctrl + Y to mean repeat. Now I'm going to click on cell B4, and on the Home tab I'll apply a background color, yellow. Now maybe I get interrupted or I'm on the phone or whatever, I come back, haven't done anything else in the meantime, I might want to apply that color to a few other cells, maybe this one right here, I can press Ctrl + Y or F4, that means repeat, and also click over here, and press F4 or Ctrl + Y, I wanna see what's happening over there too.
Now, suppose I apply a format by way of the Format Cells dialog box. I'm clicking on cell C4 right now, pressing Ctrl + 1, or Command + 1, either way activates the Format Cells dialog box. Now with this dialog box open, I'm going to go to the Font tab, and I'm gonna change first of all the background color, this time maybe I'll use green, bright green there, maybe I'll make this bold and italic both, and I might change the font size, and I might do a few other things, maybe the Number format as well, maybe I'll make this be Currency, currently it's a counting number, so make it be Currency, and do that.
So I've done five or six things here, and I've made my change. Now because I've done them within the context of a dialog box, if I then go to cell E4 for example, and press the function key F4, or Command + Y, same thing happens. In other words, I'm actually repeating five or six actions that I took while that dialog box was open. Now there are more efficient ways to do what I've just done here, but do keep in mind that Ctrl + Z, which is the real lifesaver feature, lets you undo your last action, or possibly by use of the button above the menu there, you can undo a series of actions, a whole series if you wish.
I don't want to undo right now, but we could certainly do that. If I undo these actions right here, I can then redo them with the button up here this way. See what's happening? These are things that I had done earlier. Or undo again, going back this way. The keystroke shortcut for undoing the undo, sometimes we call it redo, is Command + Y or Ctrl + Y. So at different times you might get a little bit confused as to how these features work, but keep in mind Command + Y, Ctrl + Y, does mean undo the undo, or as we sometimes call it, redo, and you can also use it for repeating certain actions as well, but the undo feature certainly is a lifesaver, something we'll use frequently as we change our mind about how things look, and of course recover from deleting cells that we really didn't want to delete.
The course then dives into data entry and editing techniques, formatting and drag-and-drop tricks, keyboard shortcuts for working with formulas, data management strategies, and chart tricks. Short on time? Make sure to check out the "Ten Tiny Tips" chapter for a quick productivity boost.
- Entering today's date or time instantly
- Converting formulas to values with a simple right-drag
- Undoing and redoing with keyboard commands
- Creating split screens fast
- Navigating in workbooks quickly
- Selecting noncontiguous ranges
- Entering data more efficiently
- Applying formatting with keyboard shortcuts
- Accelerating copying and moving data with drag and drop
- Creating formulas rapidly
- Using database techniques to work with Excel data
- Working with charts, shapes, and linked images