Tip 235 – Quickly filter data using the value of the selected cell

If you would like to filter a list of information by the contents of the cell you currently have selected, rather than turning filters on, clicking the filter drop down list and locating the item, simply right click the cell and select Filter > Filter by Selected Cells value.