Excel - Unlock the Hidden Power of Excel: Filter by Selection Tutorial - Episode 1239

1,764 views · Published 7 September 2010 · 1:20 · Indexed 16 November 2026

Channel: MrExcel.com · 2010 · Education

Watch on YouTube

Microsoft Excel Tutorial: Unlock the Hidden Power of Excel: Filter by Selection Tutorial.

Welcome to another episode of the MrExcel podcast. In this episode, we will be diving into chapter 21 of Excel 2010 in Depth, where we will be discussing the powerful feature of Filter by Selection. This feature allows you to easily filter your data by selecting specific criteria, making data analysis a breeze.

To access this feature, we will be customizing the ribbon by adding a new group called Filter by Selection. Simply go to the "Customize Ribbon" option and add the "Auto Filter" command to the group. Don't be confused by the similar "Filter" command, as that is not the one we want. We want the one labeled "Auto Filter", which was previously known as "Filter" in Excel 2007.

Once we have added the "Auto Filter" command to our ribbon, we can easily filter our data by selecting specific criteria. For example, if we want to see all the records for General Motors in the East region with the ABC code, we simply select "General Motors", click on "Auto Filter", then select "ABC", and finally click on "Auto Filter" again and choose "East". This is essentially filter by selection, and it's amazing how easy it is to use.

The reason why many people are not aware of this feature is because it is mislabeled. Microsoft should have named it "Filter by Selection" to make it more intuitive. But now that you know about it, give it a try and see how it can make your data analysis much more efficient. Thank you for tuning in to this episode of the MrExcel podcast, and we'll see you next time for more tips and tricks to excel in Excel. Don't forget to check out our sponsor, MrExcel.com, for even more Excel tools and resources."

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/


Table of Contents:
(00:00) Filter by Selection 
(00:10) Customizing the Ribbon 
(00:20) Adding the Auto Filter Command 
(00:30) Power of Auto Filter 
(00:40) Using Auto Filter for Specific Records 
(00:50) Mislabeling of Auto Filter 
(01:00) Suggestion for Microsoft 
(01:10) 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:
Auto filter
Brand new group
Chapter 21
East ABC
Excel 2010 in Depth
Filter by Selection
Filter by selection trick
General Motors records
Microsoft
Ribbon customization


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


Filter by Selection? In Excel 2010? Really? Where is it!? Podcast #1239 shows you! Access this 'secret command' hidden behind a wrong label in Excel. Add it to your Excel Ribbon to enable faster, more accurate filtering of your data.

More from this channel