Excel spreadsheet applications and tips

Home

 

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

 

Selection area search problem

Excel’s search feature not working

Selection area search in Excel

 

Search engine keywords for this question

 

Excel searching outside Selection Area

Excel not searching within selection range

Search problem Excel 2007, 2010