When the option search workbook is selected instead of search work sheet, excel will no longer search within the selection range. To solve this issue, simply opt work sheet instead of workbook in find box.
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