How to Apply AutoFilter Dropdowns in Excel

Hey! Welcome back to the Mr. Excel net cast, I’m Bill Jelen. Basically, we start out with massive amounts of data and say, “How are we going to analyze this?” Well let’s fire up and hit the table, and see if we could solve this problem.

Hey! Welcome back to the Mr. Excel net cast. I’m Bill Jelen. I’m just out here cruising around YouTube search for a three year old kid imitates Mr. Excel. And you will see Mike Girvin’s son Isaac, actually managed to come up with a couple of cool excel tips as he is wandering around kind of funny, obviously taken after his dear old Dad there.

I got a great tip today. This came from a power analyst boot camp. I was down in Dallas last week with Mike Alexander. Someone there in the audience, Mary, gave me a great tip. Now if we turn on the auto filter dropdowns, it turns on auto filters for everything. And who’s really going to come here to the remedy dropdown and choose one of these, putting on my clave here, clearing this for someone else. I said Mary had a beautiful tip, she said if you just want to put the auto filter dropdowns on the first 3, by the way I know how to do that in VVA but she had none VVA way to do it. You just insert a column that come over here, apply the filter, dropdowns on A, B and C and then delete the extra column and a great, great way to go.

Now someone else in the audience pointed out that you can also achieve this by choosing those 3 columns. And click on filter, that filter just those and of course you know once we then choose one specific customer it’s going to filter all the columns. But we only have to dropdowns on the relevant items. Very, very cool tip to go provided the columns you want are all adjacent. Otherwise we need to go over the VVA to pull that off.

While here, I want to send out this shout out to Isaac who is apparently getting in to the Excel podcast game. I want to thank you for stopping by. We will see you next time for another net cast from Mr. Excel.

Thanks for stopping by, we will see you nest time for another net cast from Mr. Excel.


Transcription by: Scribe4you Transcription Services