Look Who it Was Random video

Excel - Discover Excel's Hidden Filter by Selection Feature | Excel Tips & Tricks - Episode 851

369 views · Published 8 January 2009 · 1:35 · Indexed 20 September 2026

Channel: MrExcel.com · 2009 · Education

Watch on YouTube

Microsoft Excel Tutorial - Discover Excel's Hidden Filter by Selection Feature | Excel Tips & Tricks.

Welcome back to the MrExcel netcast! In today's episode, we're going to dive into the world of Excel filters once again. In a previous episode, I showed you a cool macro that allowed you to filter by selection. However, I was unaware that Excel actually had a built-in feature for this. Thanks to a helpful viewer, Reba, I discovered that there is a button for Filter by Selection in the Customize menu under the Data category. 

To access this feature, simply go to Tools, Customize, and select the Data category. You'll see the option for Auto Filtering, which is actually the Filter by Selection feature. Make sure to also add the Show All button to your toolbar for easy access. Now, all you have to do is select a cell and click the Filter button to filter by that selection. You can then use the Show All button to reset the filter and choose a different selection to filter by. 

I have to admit, I was completely unaware of this feature and I'm sure many of you were as well. It's a much more intuitive and efficient way to filter your data in Excel. So, a big thank you to Reba for bringing this to our attention. As a token of our appreciation, we'll be sending you an Excel Master Pin for your beautiful observation. And to all our viewers, thank you for tuning in and we'll see you next time for another netcast from MrExcel. Don't forget to hit that like button and subscribe for more Excel tips and tricks.

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/


Wiebe points out a better solution for Episode #838 - Excel already has an icon for Filter by Selection. It is hard to find and poorly labeled, but it is in there. Episode 851 shows you how.

Table of Contents:
(00:00) Access has a Filter by Selection button, Excel does not
(00:25) Reba informs about a hidden Filter by Selection button in Excel
(00:35) How to use the Auto Filtering button
(00:50) How to filter by selection using the Filter= button
(01:01) Show All button to reset filter
(01:17) 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:
Access vs Excel
Auto Filter
Auto Filtering
Customized
Data category
Excel Master Pin
Filter by Selection
Filter=
Macro for Filter by Selection
Show All
Tools menu

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

More from this channel