Excel Guides

Searching a Workbook by Default in Excel

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:

  1. Click the File tab.
  2. Click Options.
  3. Click Advanced.
  4. Under Editing options, select or clear the check box next to Enable wildcard and regular expression searches.
  5. Click OK.

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.

Move beyond 


Get started with Causal today.
Build models effortlessly, connect them directly to your data, and share them with interactive dashboards and beautiful visuals.