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

Turn Text Dates To Excel Dates With Text To Column... Whenever you import data from your company's server, ERP system or any other source for that matter, the Dates usually come in a TEXT format. I will show you a cool trick where you can turn the TEXT Date to a values Date that Excel can read and work with. DOWNLOAD EXCEL WOR...
How To Make Negative Red Numbers In Excel When you are working with lots of different numbers in Excel, you sometimes want your numbers to stand out by showing them in a negative red number with a minus sign in the front. To do this you need to select your numbers and press CTRL+1 to bring up the Format dialogue box. ...
Add Leading Zeros in Excel Do you have a lot of numbers with an uneven number of digits in your Excel list? Do you want to make them uniform by adding leading zeros to them? Well, it's a pain to add zeros in front of them one by one! Thankfully, Excel allows you to add leading zeros with one singl...
Free Excel Templates If you want ready made custom Excel templates then you do not have to pay for them as they are FREE inside your Excel workbook! To activate this you need to go to File > New and choose from a variety of categories, such as: Budgets, Planners, Lists, Invoices, Calendars, ...