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

Share on Facebook

Tweet about this on Twitter

Share on LinkedIn

Share on Google+

Related Posts

Excel Table Headers Show in Columns Before Excel Tables were introduced in Excel 2007, there were Excel Lists which had limited functionality.For example, when you had a list of data with hundreds of rows and you had to scroll all the way down to the bottom of your list, the Headers row was not visible and you ...
Show Averages With an Excel Pivot Table A Pivot Table is the most powerful feature within Excel as it allows you to analyze your data in many different ways, all with a press of a button.The Summarize Values By option allows you to choose a type of calculation (Sum, Count, Average, Max, Min, Count Numbers Produ...
Show The Difference From Previous Years With Excel... Excel Pivot Tables have heaps of calculations under the SHOW VALUES AS option and one that gets the most use is the DIFFERENCE FROM calculation.You can show the values as the Difference From previous months, years, day etc.  This is just great when your boss asks you how you ...
Distinct or Unique Count with Excel Pivot Tables Excel 2013 added some new features to its arsenal and one that has been well overdue was the distinct or unique count.Previously when we created a Pivot Table and dropped a Customers field in the Row Labels and then again in the Values area we got the "total number of transac...