Excel Shortcuts - Add to Selection - Episode 2127
1,503 views · Published 9 August 2017 · 0:48 · Indexed 6 November 2026
Channel: MrExcel.com · 2017 · Education
Microsoft Excel Tutorial - Shortcut to Add to Selection in Excel Welcome to another episode of Learn Excel From MrExcel. In this podcast, episode 2127, we will be discussing a handy shortcut that can save you a lot of time and effort when working with large ranges of data in Excel. This shortcut is SHIFT+F8, and it allows you to enter a mode called ADD TO SELECTION. So, what exactly does ADD TO SELECTION do? Well, let's say you have a range of cells selected and you need to add more ranges to your selection. Instead of manually clicking and dragging to select each range, you can simply hold down SHIFT and press F8. This will put you in ADD TO SELECTION mode, and you can then use your mouse to select the additional ranges you need. Just remember to hold down CONTROL while selecting each range. Once you have all the ranges you need selected, you can then apply any formatting or changes to the entire selection. And when you're done, simply press ESCAPE or apply any formatting to exit ADD TO SELECTION mode. This shortcut can be a real time-saver when working with large amounts of data in Excel. Thanks for tuning in to this episode of Learn Excel From MrExcel. Be sure to subscribe to our channel for more helpful tips and tricks for mastering Excel. We'll see you next time for another informative 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 collums in excel how do i select non contiguous rows in excel how do i select non contiguous cells in excel what is add to selection mode in excel select non-contiguous ranges in excel Table of Contents: (00:00) Explanation of SHIFT+F8 shortcut (00:10) How to use ADD TO SELECTION mode (00:20) Exiting ADD TO SELECTION mode (00:31) Clicking Like really helps the algorithm Join the MrExcel Message Board discussion about this video at https://www.mrexcel.com/board/threads/1153952/
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