Picture this: you have a lot of reformatting to do on your spreadsheet and there are pockets of different formatting sprinkled throughout. Finally theres a shortcut to speed up that process!
In this video, I will teach you how to select multiple cells that arent next to each other without touching the mouse.
Download FREE Hands-On Exercises
Full Video Transcript:
Have you ever tried to select multiple cells that were not next to each other?
Sure, theres CTRL + CLICK for the PC. Theres COMMAND + CLICK for the Mac. But in this video, Im going to teach you the shortcut to select non-adjacent cells using only the keyboard.
If you want to select cells that are not next to each other using the mouse, the way to do it primarily is with the keyboard, pressing and holding the CTRL key and then clicking with the mouse. This is probably what youve done thus far. You can even click and drag and get a whole range going. Thats for the PC. For the Mac, its the same thing, except instead of CTRL, youre using COMMAND, keeping it pressed, and then clicking around that way.
However, if you ever want to use the keyboard only, the way to do it is with SHIFT + F8. And the memory trick is, You should have come along, you funny mate! Which is terrible, I know. This is a terrible trick, but hey, it actually helps you remember. The should is the Shift, and the funny mate sounds like eight, so its kind of like, you know, close, I guess.
Either way, the way to do it here is to keep SHIFT + F8 pressed now, and then move with the ARROWS. And what that does is it keeps that selection in place before moving. If I Shift down and to the right, for example, and then hit SHIFT + F8 again, I can safely move without losing that selection.
So thats the whole trick. Before you move, you want to hit the SHIFT + F8. Otherwise, you will lose your work, right? If I hit SHIFT + ARROWS and then I move aside without hitting SHIFT + F8, I start from scratch. So thats a big tip right there, is not to do that until youre done and you actually have it all selected that you want.
So theres one more nuance, which is that if you want to take an entire range, youll go ahead and hit SHIFT + F8 once, move aside, as we saw. But if you want to take a single cell, youll hit SHIFT + F8 twice before moving on. Otherwise, it will not work. So if its a single cell, you hit it twice. And if its a range of cells, you hit SHIFT + F8 once before you move.
Ive created a series of exercises for you to practice this shortcut specifically. So the way to do it is to go to the Non-Adjacent Ranges tab. You want to match the format. Everything thats on the left here, you want to make it look identical to the way it is in the example on the right. The only difference here is the bolding. But use the shortcut that we just learned.
So select all of these, hit SHIFT + F8, and then that way, youll get it all selected before you even apply the bold. And you would do it all in one swoop, and thats kind of the whole benefit of this shortcut. Thats for the ranges.
The next tab is going to be the same thing but with individual cells. Notice, youre going to hit SHIFT + F8 the first time just once, but afterwards, SHIFT + F8 twice before you move on. Otherwise, it will not work. And thats the whole trick there.
Finally, if youre feeling adventurous, youll go to this Non-Adjacent Challenge and youll do all of these in one selection without using the mouse. And that way, you can practice all of this together.
Dont forget to visit excelshir.com, where you can download these exercises, along with other free resources, such as keyboard shortcut cheat sheets for both PC and Mac.
Thanks for watching. See you next time. And if you can only take a stand for one thing in your life, take a stand for sharing the Excel love. That sounds like someone I would stand for.