Excel - How To Select Many Ranges In Excel No Mouse - Shift+F8 Add to Selection - Episode 1945
Microsoft Excel Tutorial: Selecting Multiple Ranges in Excel without the Mouse.
Welcome to the MrExcel podcast. In this episode, we will be discussing the Shift+F8 Add to Selection feature in Excel.
This tip came from Neil Charles (@data_monkey on Twitter). He shared the Shift+F8 feature, which allows you to lock a selection and move around to select other cells. This is especially useful for charting, as it eliminates the need to constantly reach for the mouse. And this is just one of the many great tips that have been shared with me through this project. I am truly grateful for the support and collaboration of the Excel community.
In the meantime, let's dive into some more great Excel tips. In this episode, we will be discussing two more tips that have been shared with me through this project. The first one comes from Colleen Young, who showed us how to easily find and highlight differences between two sets of data. And the second one is another great tip from Neil Charles, who introduced us to the Shift+F8 feature. These are just a taste of the amazing tips that will be featured in the book, and I can't wait for you to discover them all.
Thank you for tuning in to this episode of the MrExcel podcast. I hope you enjoyed these Excel tips and are as excited as I am for the release of "MrExcel XL: The 40 Greatest Excel Tips of All Time". Don't forget to join us on IndieGoGo and be a part of this exciting project. Stay tuned for more great Excel tips and tricks in future episodes. Until next time, this is Bill Jelen, signing off.
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-...
Table of Contents
(00:00) Select multiple ranges without the mouse
(00:13) Crowdfunding MrExcel XL book
(02:11) Vote for favorite tip
(03:00) Shift+F8 allows you to select additional ranges
(03:19) F8 is Extend Selection
(03:43) Select 3 ranges using Shift+F8
(04:08) Avoid using the mouse
(04:20) Add to Selection in Status Bar
(04:45) Repeat Shift+F8 for next range
(05:35) Compare two columns of numbers using Go To Special Row Differences
(06:22) Clicking Like really helps the algorithm
#excel #microsoft #microsoftexcel #exceltutorial #exceltips #exceltricks #excelmvp #freeclass #freecourse #freeclasses #excelclasses #microsoftmvp #walkthrough #evergreen #spreadsheetskills #analytics #analysis #dataanalysis #dataanalytics #mrexcel #spreadsheets #spreadsheet #excelhelp #accounting #tutorial
This video answers these common search terms:
how to select data ranges in excel without click and drag
how do you select multiple ranges in excel
how to select non adjacent ranges excel
how to select non adjacent ranges in excel
how do i select nonadjacent ranges in excel
excel how to select multiple ranges
how to select the nonadjacent ranges excel
how to select multiple non adjacent ranges in excel
While collecting possible tips for my 40th Excel book, I ran across two tricks that were new to me. Shift+F8 lets you select non-contiguous ranges without using Ctrl+Mouse. And Go To Special Row Differences. For more info about the book: http://mrx.cl/xlbook40
Join the MrExcel Message Board discussion about this video at https://www.mrexcel.com/board/threads...
Watch video Excel - How To Select Many Ranges In Excel No Mouse - Shift+F8 Add to Selection - Episode 1945 online without registration, duration hours minute second in high quality. This video was added by user MrExcel.com 05 January 2015, don't forget to share it with your friends and acquaintances, it has been viewed on our site 5,152 once and liked it 52 people.