In this short screencast, I'm going to explain a little bit more about editing the Excel worksheet. In some of the other screencasts, I've already mentioned a few things about this, so let me just go through those real quick. I could highlight these three cells and I could do either right-click, cut or I like to use the shortcut key, Control-X, for cut. You notice that it hasn't cut that like in other software applications like Word, if you cut something, then it's automatically cut to your clipboard, it doesn't do that. Its got these ants marching around the outside to show that it's currently cut, and then you can click on a different cell and you could do right-click, paste or you could do Control-V. So I'm going to do do Control-V. So that's how you can cut and paste. You can also copy, so if I did Control-C or right-click, copy. I'll do right-click, copy and then you can right-click there, and we can do Control-V to paste. There are some other ways in which you can paste things; if you right-click, so let me go ahead and copy this, this 8, 10, 7, if I right click somewhere over here maybe, it brings up this menu of our different paste options. So paste here is what I did using Control-V. You can also just paste the values, I'll show you that in a minute. If you wanted to, you could paste the formulas. We can also transpose. So I'm going to go ahead and click on transpose. Transpose basically swaps the rows and columns of any array. So here we have 8, 10, 7. So now we go 8, 10, 7 as a column. Let's say I had a formula in here. Let me just do equals 3 plus 5. This actually is a formula. It's got three plus five in there, and I can double-click on that and see that. So if you copy this, Control-copy, and if you paste that up here, paste formula, then it's actually got the same formula as that cell that I copied from. However, if you just wanted to paste the value, a lot of times all you want is the value. Then we can do Control-copy, and I can right-click and I can do this, paste values, this clipboard with the 1, 2, 3. In that case, if we look up here in the formula bar, and if I double-click in there, all it is is an eight. It's just the value. So this can be very beneficial for some applications where you only want to keep the value and not the formula. I've already talked about this in previous screencasts, but up here on the quick access toolbar, you can undo using this back arrow and you can redo, and if you hover over that, it tells you what you're going to redo. So in this case, I'm going to redo the paste special where you can undo quite a few moves. So I could go back quite a few moves, and if I want to go forward again, then I can press the redo. You can also use Control-Z to undo and Control-Y to go forward and to redo. There's a big difference between deleting something in Excel and just clearing the contents. I'm going to go ahead and click in this cell here, 13, and I'm going to right-click and I'm going to do delete. Deleting will remove the cell from the worksheet and shift everything either up or to the left. I've already shown this in one of the screen cast, but this is so important that I wanted to reemphasize it. So we can either shift cells left or up. In this case, I'm going to shift them left, and you see that everything to the right of it has shifted left. It's basically removing that permanently from the spreadsheet. I'm going to go ahead and undo by using Control-Z. If you just want to clear the contents, you can press the delete key and it clears it, but it keeps that cell on the spreadsheet. You can also do the same thing by right-clicking and doing clear contents. So that's another way that you can clear the contents of any cell. Hopefully you learned a little bit more about editing the worksheet in this screencast.