Excel spreadsheet applications and tips
MS Excel not searching within selection range
When the option search workbook is selected instead of search work sheet, excel will no longer search within a selection range. Simply opt work sheet instead of workbook in find box to solve the problem.
Please refer to the following excel spreadsheet to see how.
External links for other issues that might cause this problem
Search engine keywords for this question
Excel searching outside Selection Area
Excel not searching within selection range
Search problem Excel 2007, 2010