This secret command is hidden behind a wrong label in Excel. Add it to your Excel Ribbon to enable faster filtering.
Transcript of the video:
MrExcel podcast is sponsored by Easy-XL.
Excel 2010 in-depth chapter 21, Filter by Selection Hey, welcome back to the MrExcel netcast. I am Bill Jelen.
I'm just in the process of customizing the Ribbon here.
I'm adding a brand new group called Filter by Selection.
And I went to all commands in the left hand side and found this command called AutoFilter.
Now, I don't want you to use Filter; Filter is there.
That's not the one we want, we want the one that's called AutoFilter, which is really strange, since they renamed AutoFilter to be filtered back in Excel 2007, so I'll add that to the group, click OK and so now I have this brand new icon called AutoFilter, which is much more powerful than the filter icon.
Let's say, I want to see all the General Motors records for East ABC.
Watch how easy this is. Choose General Motors, click AutoFilter, choose ABC AutoFilter, East AutoFilter, essentially, that's Filter by Selection. Isn't that amazing, how easy it is?
The reason no one knows is there, it is mislabeled.
Microsoft should really call this Filter by Selection, people would start to use it all the time.
A great, great trick, try it out.
Hey, I want to thank you for stopping by. See you next time with another netcast from MrExcel.
Excel 2010 in-depth chapter 21, Filter by Selection Hey, welcome back to the MrExcel netcast. I am Bill Jelen.
I'm just in the process of customizing the Ribbon here.
I'm adding a brand new group called Filter by Selection.
And I went to all commands in the left hand side and found this command called AutoFilter.
Now, I don't want you to use Filter; Filter is there.
That's not the one we want, we want the one that's called AutoFilter, which is really strange, since they renamed AutoFilter to be filtered back in Excel 2007, so I'll add that to the group, click OK and so now I have this brand new icon called AutoFilter, which is much more powerful than the filter icon.
Let's say, I want to see all the General Motors records for East ABC.
Watch how easy this is. Choose General Motors, click AutoFilter, choose ABC AutoFilter, East AutoFilter, essentially, that's Filter by Selection. Isn't that amazing, how easy it is?
The reason no one knows is there, it is mislabeled.
Microsoft should really call this Filter by Selection, people would start to use it all the time.
A great, great trick, try it out.
Hey, I want to thank you for stopping by. See you next time with another netcast from MrExcel.
