To change the default search settings in Excel, follow these steps:
Click on the File tab.
Click Advanced. The Advanced options dialog box appears.
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).
Get started with Causal today. Build models effortlessly, connect them directly to your data, and share them with interactive dashboards and beautiful visuals.