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!