Pinterest Pixel

Excel Filter by Selection

When you have an array of data in Excel you can quickly select an item and press... read more

Download Excel Workbook
John Michaloudis
Posted on

Overview

Excel Filter by Selection | MyExcelOnline Excel Filter by Selection | MyExcelOnline

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.

Excel Filter by Selection | MyExcelOnline
Download workbookFilter-by-Selection.xlsx

This is our data table.

Excel Filter by Selection

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

Excel Filter by Selection

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

Excel Filter by Selection

You can now see the AutoFilter icon on top.

Excel Filter by Selection

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

See also  Compare Two Columns in Excel for Matches & Differences: 3 Useful Methods

Let us say we want to filter the data by Region – North. Click on any NORTH value.

Afterwards click on the AutoFilter icon.

Excel Filter by Selection

Your table is now filtered by the NORTH REGION with a single click!

Excel Filter by Selection

 

 

 

If you like this Excel tip, please share it
Excel Filter by Selection | MyExcelOnline Excel Filter by Selection | MyExcelOnline

Get Video Training

Advance your Microsoft Excel & Office Skills with the MyExcelOnline Academy!

Dramatically Reduce Repetition, Stress, and Overtime!
Exponentially Increase Your Chances of a Promotion, Pay Raise or New Job!

Learn in as little as 5 minutes a day or on your schedule.

Learn More!

Share to...