To change the default search settings in Excel, follow these steps:

1. Open Excel.
2. Click on the File tab.
3. Click Options.
4. Click Advanced. The Advanced options dialog box appears.

5. 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).










---