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
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
-
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