Notice: This website is an unofficial Microsoft Knowledge Base (hereinafter KB) archive and is intended to provide a reliable access to deleted content from Microsoft KB. All KB articles are owned by Microsoft Corporation. Read full disclaimer for more details.

You cannot find the data that is in a filtered list by using Find command in Excel

View products that this article applies to.


When you search a Microsoft Excel workbook for data, you may receive the following error message:
Microsoft Excel cannot find the data you're searching for. Check your search options, location and formatting.

↑ Back to the top


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

↑ Back to the top


To work around this behavior, select each sheet, set the filter criteria to Show All, and then perform the search.


To show all data in a filtered list in Microsoft Office Excel 2003, click a cell in the filtered list. Then, point to Filter on the Data menu, and then click Show All.

To show all data in a filtered list in Microsoft Office Excel 2007, click the arrow in the column header in the filtered list, and then click Select All.

↑ Back to the top

Keywords: KB282142, kbprb, kbpending, kberrmsg, kbexpertisebeginner, kbtshoot

↑ Back to the top

Article Info
Article ID : 282142
Revision : 4
Created on : 2/6/2007
Published on : 2/6/2007
Exists online : False
Views : 272