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

Watch on YouTube

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