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