Sign in with Microsoft
Sign in or create an account.
Select a different account.
You have multiple accounts
Choose the account you want to sign in with.


When you try to use the Find utility to search for data in an Excel workbook, you may receive an error message similar to the following:

Microsoft Excel cannot find the data you're searching for. Check your search options, location and formatting.


This issue may occur if you are searching for text, values, or formatting that is contained in a filtered list, and the filtering criteria prevents the text, values, or formatting from being displayed.


To work around this issue, set the filter criteria to Show All on each worksheet in your workbook before you perform the search. To do this, follow these steps:

  1. Start Excel, and then open the workbook that you want to search.

  2. On the Data menu, point to Filter, and then click Show All.

  3. Repeat step 2 for each sheet in the workbook.

  4. Perform the search.


Microsoft has confirmed that this is a problem in Excel 2003.

Need more help?

Want more options?

Explore subscription benefits, browse training courses, learn how to secure your device, and more.

Communities help you ask and answer questions, give feedback, and hear from experts with rich knowledge.

Was this information helpful?

What affected your experience?
By pressing submit, your feedback will be used to improve Microsoft products and services. Your IT admin will be able to collect this data. Privacy Statement.

Thank you for your feedback!