Filter by Selection? In Excel 2010? Really? Where is it!? Podcast #1239 shows you! Access this 'secret command' hidden behind a wrong label in Excel. Add it to your Excel Ribbon to enable faster, more accurate filtering of your data.
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'm 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 on the left hand side and found this command called Auto filter.
Now, I don't want you to use filter.
Filter there, that's not the one we want.
We want the one that's called auto filter.
Which is really strange.
Since they renamed auto filter to be filter, Back in excel 2007.
So,add that to the group.
Click [ OK ] and so now I have this brand new icon called Auto Filter.
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 [ auto filter ].
Choose ABC, [ Auto filter ], East [ Auto Filter ].
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.
Will see you next time for another netcast, from MrExcel.
Excel 2010 in Depth, chapter 21.
Filter by Selection.
Hey, Welcome back to the MrExcel netcast.
I'm 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 on the left hand side and found this command called Auto filter.
Now, I don't want you to use filter.
Filter there, that's not the one we want.
We want the one that's called auto filter.
Which is really strange.
Since they renamed auto filter to be filter, Back in excel 2007.
So,add that to the group.
Click [ OK ] and so now I have this brand new icon called Auto Filter.
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 [ auto filter ].
Choose ABC, [ Auto filter ], East [ Auto Filter ].
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.
Will see you next time for another netcast, from MrExcel.
