A Quick Way To Filter In Excel

Here is a very quick way to filter you data range in Excel:

You can download the file here and follow along. If you get a preview, look for the download arrow in the upper right hand corner.

Yesterday we looked at Advanced Filter (take a look at it here if you didn’t get a chance to view it), and today I want to show you a very quick way to filter information from a data range.

Here I have a range of data showing a list of inventory items:


If I want to filter this by “Vertical piping” in the “Description” column, there are a few ways to do it:

1) Sort by the Description column and view that range of data;
2) Use the standard Filter option in Excel on the Data tab – add filters, de-select all and then choose Vertical piping from the list;
3) Use Advanced Filter as detailed in yesterday’s post

But maybe the easiest way would be the following:

1) Right click on any instance of “Vertical piping” in the “Description” column;
2) Click on Filter=>Filter By Selected Cell’s Value:


Excel will active the Filter option and filter the data by the selected cell:


It’s that simple!

Happy Excelling!

Free Download!

Subscribe to Download Your FREE Copy of
"My 70+ Favorite Excel Keyboard Shortcuts" Today!

No comments yet.

Leave a Reply