Excel Cell Selection: Non-Contiguous Cells - Episode 2125

3,254 views · Published 7 August 2017 · 1:19 · Indexed 4 November 2026

Channel: MrExcel.com · 2017 · Education

Watch on YouTube

Microsoft Excel Tutorial: Microsoft Excel - How to Select Multiple Ranges in Excel | Excel Tips & Tricks.

Welcome to another episode of Learn Excel From MrExcel! In this podcast, episode 2125, we will be discussing how to select non-contiguous cells in Excel using some handy shortcuts. 

Let's say we have a range of cells selected and we need to also select another range that is not adjacent to the first one. Instead of clicking and dragging to select the additional range, we can simply hold down the CONTROL key and use the mouse to select the cells we need. This is a great time-saving trick when we need to format multiple ranges at once. 

But that's not all, there are a few more cool tricks related to this one. For example, if we have an active cell and we want to select all the cells below it, we can hold down the SHIFT key while selecting and it will select from the active cell down to the SHIFT key. And of course, we can still use the CONTROL key to select non-contiguous cells within that range. 

Here's another handy shortcut. Let's say we need to select a range of cells that is not visible on our screen, perhaps it's way off to the side. We can use the GO TO function by pressing CONTROL+G or F5 and typing in the cell reference we want to go to. But here's the trick, hold down the SHIFT key when clicking OK and it will select from our current location to the cell we specified. This is a great way to quickly select non-contiguous cells that are not visible on our screen. 

Thank you for tuning in to this episode of Learn Excel From MrExcel. We hope these shortcuts will help you become more efficient in your Excel tasks. Don't forget to subscribe to our channel for more helpful tips and tricks. See you next time for another netcast from MrExcel!

Buy Bill Jelen's latest Excel book: https://www.mrexcel.com/products/latest/

You can help my channel by clicking Like or commenting below: https://www.mrexcel.com/like-mrexcel-on-youtube/

#excel
#microsoftexcel
#exceltricks
#excelshortcut
#evergreen
#shortcutkey

This video answers these common search terms:
how to select non contiguous columns in excel
how do i select non contiguous rows in excel
how do i select non contiguous cells in excel
how do i select non contiguous ranges in excel
select non-contiguous ranges in excel

Table of Contents:
(00:00) Selecting Non-Contiguous Cells using Ctrl key
(00:21) Selecting from active cell to SHIFT key with SHIFT key held down
(00:41) Selecting from non-adjacent cells using CONTROL+G or F5
(00:55) Using SHIFT key with GO TO dialog box
(01:05) Clicking Like really helps the algorithm

Join the MrExcel Message Board discussion about this video at  https://www.mrexcel.com/board/threads/1153950/

More from this channel