Excel - 馃攳 Filter by Selection is 馃憖 Hidden in Excel - Excel In Depth - Episode 1211.121
1,521 views 路 Published 17 July 2010 路 1:20 路 Indexed 18 October 2026
Channel: MrExcel.com 路 2010 路 Education
Microsoft Excel Tutorial: Filter by Selection is hidden in Excel Welcome to the MrExcel netcast. In this episode, we will be diving into Excel 2010's Filter by Selection feature. I'm Bill Jelen and I'm excited to show you how to make the most out of this powerful tool. As I was customizing my Ribbon, I came across the AutoFilter command and knew I had to add it to my new group called Filter by Selection. Don't be fooled by the similar name, this is not the same as the regular Filter command. AutoFilter is much more powerful and allows you to easily filter data by specific criteria. Let's say you want to see all the records for General Motors in the East region with the ABC code. With Filter by Selection, it's as easy as selecting General Motors, clicking AutoFilter, and choosing ABC and East. It's that simple! It's a shame that this feature is often overlooked due to its misleading name. Microsoft should really rename it to Filter by Selection to make it more user-friendly. I highly recommend giving this feature a try in your next Excel project. It's a great time-saving trick that will make your data analysis much more efficient. Thank you for tuning in to this episode of the MrExcel netcast. Don't forget to subscribe and hit the notification bell to stay updated on our latest Excel tips and tricks. See you next time!" 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 in Excel (00:10) Add Filter by Selection (AutoFilter) to Ribbon (00:34) AutoFilter will filter by selection (00:45) General Motors and ABC (00:58) 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 #excelfilter #exceldatafiltering #filter #filterfunction #filterbyselection This video answers these common search terms: excel filter by selection filter based on selected cell value in excel how to filter by selected data in excel excel filter using selected criteria filter with active cell value in excel limiting data with selected cell filter in excel filtering data using current selection in excel apply filter based on selected content in excel Join the MrExcel Message Board discussion about this video at https://www.mrexcel.com/board/threads/1152894/
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