When you search for a workbook in Excel, the default search behavior is to look through all of the worksheets in the workbook for the specified text. You can also choose to search only certain types of data, such as formulas, comments, or values. To change the default search behavior, do the following:
Click the File tab.
Under Editing options, select or clear the check box next to Enable wildcard and regular expression searches.
Now when you perform a search, any text that matches the search criteria will be highlighted in the results. To learn more about using wildcard and regular expression searches, see Search for data by using wildcard characters.
Get started with Causal today. Build models effortlessly, connect them directly to your data, and share them with interactive dashboards and beautiful visuals.