MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Excel Shortcuts - Non-Contiguous Cells


August 07, 2017 - by Bill Jelen

Excel Shortcuts - Non-Contiguous Cells

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.

Watch Video

Video Transcript

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


Bill Jelen is the author / co-author of
Excel Dynamic Arrays Straight to the Point

The new Dynamic Array Functions are just one side-effect of an effort to completely rewrite the Calculation Engine in Excel. Joe McDaid and the rest of the CALC team have the laid the groundwork for all future functions in Excel. Yes, the first crop of SORT, SORTBY, FILTER, UNIQUE, SEQUENCE and RANDARRAY are awesome and powerful, but they are just the first of many new functions that will come to Office 365 over the coming years.