Excel Shortcuts - Non-Contiguous Cells
August 07, 2017 - by Bill Jelen
Today's article covers how to select non-contiguous cells in Excel. Sure - you can hold down Ctrl while selecting multiple ranges. But there are other ways.
If you have to select two regions, select the first one, then hold down Ctrl while clicking on other cells or regions.
Thanks to Thomas Fries for sending in this idea.
Learn Excel From MrExcel, Podcast Episode 2125: Selecting Non-Contiguous Cells.
Alright, so, let's say that we have this range selected here and we do CONTROL*,but then I also need to select this range over here. So, what I'm going to do is I'm going to hold down the CONTROL key and, with the CONTROL key held down, select using the mouse, alright?
So, that's a great way to select multiple ranges if we needed to format all of those. A couple more cool tricks here that are related to this one. If that's the active cell and we hold down the SHIFT key while we select here, that will let us select from the active cell down to the SHIFT key, you know, and then, from there, you're still going to use CONTROL click.
Or another really weird one. Let's say that we're sitting out here in O29 and I need to select up to B13, but let's go even further. Let's say that we're way off the edge of the screen. So, we need to select from here to B13. I can use CONTROL+G or F5 to get the GO TO, type B13 like that, but then hold down the SHIFT key when you click OK, and it will select from where we were to the spot where we wanted to go, see? So, using SHIFT with the GO TO dialog box.
I want to thank you for stopping by. We'll see you next time for another netcast from MrExcel.
Title Photo: TeroVesalainen / Pixabay