By Susan Harkins
January 27, 2012, 6:42 AM PST
Takeaway: When you just need to see matching values and you don’t want to filter or sort, try this Excel keyboard trick.
There are numerous ways to find matching data in an Excel sheet. Filters are probably the most versatile. Sorting is probably the easiest way, but even that’s unnecessary if all you want to do is review matching values. In other words, if you don’t need the values rearranged or filtered, there’s a quicker way. Excel offers a keyboard shortcut trick that’s quick to implement and easy to remember.