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
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
-
2:13
Excel Calculate Decimal Hours from two Time Cells - Episode 902
-
3:57
Excel 2007 - Color of Selected Sheets is too much like unselected sheets - Episode 907
-
2:48
Excel - Adding Equals Icon to Excel QAT - Build Formula with Mouse - Episode 911
-
3:30
Excel Grouping Percentages into Buckets for a Pivot Table - Method 2 - Episode 913
-
2:04
Excel Change Color of Selected Cells - Episode 914
-
4:38
Excel - Auto Numbering a List with Frequent Inserts & Deletes - Episode 916
-
2:00
Excel Hiding Data in Plain Site - Episode 919
-
2:20
Excel - Bring Back The Full Excel 2003 Dialogs In Excel! - Episode 920