Transcription
Let’s say you’re in Excel, and you want to select all the rows that are in your sheet. You could just use your mouse, select the first option, click, hold the left mouse button, drag, and then pull all the way down. But you know, you might have a bunch of rows that you’re dealing with, and you don’t want to do this manually. Well thankfully there’s an easy way around this and I just wanted to show you guys.
So if you go back to the top, for example, and you select the first cell and then hold shift on your keyboard, and use the arrow keys, here I’m pressing to the right, you can see that I’m able to select cells, so I’m gonna select all of these cells. I can then press down to select more cells, but that’s not what I’m here to show you. I’m here to show you that if I just select the first row, and then, while I”m still holding SHIFT, I press CTRL, and then press down on the arrow keys, it selects everything. So when you get used to this, it’s actually a really quick way to select just the cells you want to select.
Here it is one more time. Select the first cell, hold SHIFT, press the right arrow key, until you’ve selected them all. Hold CTRL, press arrow key down – there you go, they’re all selected.
Now let’s do the opposite, let’s go from the bottom. So I’m going to select this cell, we’re going to do SHIFT, left arrow key until we select them all, hold CTRL, arrow key up. Oh, look at this! It worked, but it selected the title here. Maybe we don’t want that. So there’s two ways to fix this – you hold SHIFT, press arrow key down, and it adjusts. Or what I like to do in my sheets sometimes is select the cell right below the actual title row, and just say Insert. This will create an empty row. Then all I have to do with this is just make it really tiny, okay. And then if you go to the bottom, and select the bottom cell again, we’re gonna hold shift, arrow key left, hold CTRL, arrow key up – you’ll notice that it selected everything but it stopped. And it does that because the row that I added is empty. Because it’s empty, it kind of knows that that’s the end of what I wanted to select.
The same thing works for horizontal sheets – so for example, in this case, I’ve got a bunch of columns – they’re nonsense columns, but they’re a bunch of columns nonetheless. If I wanted to select them, I would click on the cell, I would hold SHIFT, arrow key down, until the end, then I would hold – start holding CTRL, then I would press arrow key right, once. And it would select everything.