Use Filter By Selected Cell’s Value to save time [Quick Tips]

We are busy decorating the Christmas tree, making preparations for the holidays. But I have a very quick tip for you.

[Note: all these tips work in Excel 2007 or above]

Whenever you are working with huge lists of data, filtering & sorting is one simple way to analyze the data quickly.

You can quickly filter your data based on current cell’s value by right clicking and then selecting filter > filter by selected cell’s value.

You can even filter by selected cell’s color, font or conditional formatting icon.
You can also sort a list by selected cell’s column in either ascending or descending order.
You can instantly turn on / off filters by pressing CTRL+SHIFT+L

Share this tip with your colleagues

Overall I learned a lot and I thought you did a great job of explaining how to do things. This will definitely elevate my reporting in the future.

Rebekah S

Reporting Analyst

Related Tips

Excel Howtos