Find What You Want Where You Want

If you work with large amounts of data, you probably find yourself in need of searching for specific items in specific regions of your Excel worksheets. The Find function (Ctrl+F) is one of Excel's most frequently used tools for this purpose.

There are times, of course, when you do not want to search All of your data. If you want to narrow your search to a specific range in your worksheet, (a single column, for instance), you can simply select the range you want to search before pressing Ctrl+F. When the search is performed, only the selected range is included in the exploration, and all else is ignored.

Select your range and hold Ctrl+F. Bamm! There’s your data!