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

Watch on YouTube

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