When you have an array of data in Excel you can quickly select an item and press the AutoFilter button which will filter that selection in your data.

You can then go over to another column within your data and select another item, apply the same steps above and further filter your data.

This is a quick and easy way to drill down into your data.

For this trick to work you need to put the AutoFilter button in the Quick Access Toolbar by going to File > Options > Quick Access Toolbar.

Then you need to go to Choose commands from > All Commands > AutoFilter > Add > OK

You can then click anywhere in your data, click the AutoFilter button in your Quick Access Toolbar and see the magic!

DOWNLOAD WORKBOOK

Filter by Selection

THIS TIP WAS INSPIRED BY:

mrexcelXL

 

 

 

If you like this Excel tip, please share itEmail this to someone

email

Pin on Pinterest

Pinterest

Share on Facebook

Facebook

Tweet about this on Twitter

Twitter

Share on LinkedIn

Linkedin

Share on Google+

Google+

Related Posts

Top Excel Data Cleansing Techniques Data cleansing is an important activity within Excel and one that we find ourselves doing day in day out, sometimes without even knowing it. So what is data cleansing? In the words of Oz du Soleil, Excel MVP, it is like "Hercules being sent out to capture the three-he...
Use Excel Goal Seek To Find The Formula Result You... If you have a formula and want to show a specific result, but you do not know what input values to change within the formula, then Excel's Goal Seek feature is the one for you. Imagine you are calculating the payment terms on a loan. Your PMT formula gives you an amount of ...
Show The Percent of Parent Column Total With Excel...   Excel Pivot Tables have a lot of useful calculations under the SHOW VALUES AS option and one that can help you a lot is the PERCENT OF PARENT COLUMN TOTAL calculation. This option will immediately calculate the percentages for you from a table filled with numbers suc...
Turn Text To Values With Paste Special Values Many times you would have received data from your IT system which is formatted wrong!  Well a gazillion times if you work in a mid sized firm 🙂 When you try and sum the values you get a count rather than a sum, that is because Excel reads the data as text rather than a value....