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

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) Introduction by Bill Jelen
(00:18) Recap of previous episode's Macro
(00:21) Access has a Filter by Selection button, Excel does not
(00:25) Reba informs about a hidden Filter by Selection button in Excel
(00:38) How to use the Auto Filtering button
(00:45) Auto Filter and Show All buttons must be selected
(00:50) How to filter by selection using the Filter= button
(01:01) Show All button to reset filter
(01:07) Excel Master Pin awarded for discovering hidden Filter by Selection button
(01:14) 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/