To change the default search settings in Excel, follow these steps:
In the "General" section, do one of the following:
"When finding cells with specific content, look in:": This setting determines whether to search only the current sheet or the entire workbook when you use the Find and Replace dialog box (Ctrl+F) to find specific content in a worksheet. To search only the current sheet, select (Sheet). To search the entire workbook, select (Workbook). The default is (Workbook).