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

Auto-Generated Transcript

  • Learn Excel from MrExcel Podcast Episode
  • episoda 2125 selecting non-contiguous
  • sells all right so let's say that we
  • have this range selected here we do
  • control asterisk but then I also need to
  • select this range over here so I'm going
  • to do is I'm gonna hold down the control
  • key and with the control key held down
  • I 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 shifted key you know and then
  • from there you're still going to use
  • ctrl click or another really weird one
  • let's say that we're sitting out here in
  • a twenty nine and I need to select up to
  • be 13 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
  • be 13 I can use ctrl G or f5 to get to
  • go to type B 13 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 a go-to dialog box 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.