Microsoft Knowledge Base

XL: Find Feature does Not Work on Filtered List
Last reviewed: September 13, 1996
Article ID: Q127060
The information in this article applies to:
  • Microsoft Excel for Windows, version 5.0, 5.0c
  • Microsoft Excel for Windows NT, version 5.0
  • Microsoft Excel for Windows 95, version 7.0
  • Microsoft Excel for the Macintosh, versions 5.0, 5.0a

SYMPTOMS

If Microsoft Excel, if you filter a database using either the AutoFilter feature or the Advanced Filter (with filtering in-place) feature, the Find command (on the Edit menu) may not work on the filtered list. It will find the first occurrence of the string you are trying to find, but it will not find any other occurrences in the filtered list or on your worksheet.

WORKAROUND

In order to have the Find feature work on a filtered database, you must first select just the visible cells in the range of cells from the filtered list in which you want to find your string. To select just the visible cells in a filtered list:

  1. Select all of the cells in the filtered list.

  2. From the Edit menu, choose GoTo.

  3. In the Go To dialog box, click the Special button.

  4. In the Go To Special dialog box, select Visible Cells Only, and then click the OK button. The Find feature will now work properly.

REFERENCES

"Microsoft Excel User's Guide," version 5.0, Chapter 21, "Sorting and Filtering Data in a List"

For more information about Filtering, choose the Search button in Help and type: 

    Filtering Lists

KBCategory: kbusage
KBSubcategory:

Additional reference words: 7.00 5.00 XL5 Auto



THE INFORMATION PROVIDED IN THE MICROSOFT KNOWLEDGE BASE IS PROVIDED "AS IS" WITHOUT WARRANTY OF ANY KIND. MICROSOFT DISCLAIMS ALL WARRANTIES, EITHER EXPRESS OR IMPLIED, INCLUDING THE WARRANTIES OF MERCHANTABILITY AND FITNESS FOR A PARTICULAR PURPOSE. IN NO EVENT SHALL MICROSOFT CORPORATION OR ITS SUPPLIERS BE LIABLE FOR ANY DAMAGES WHATSOEVER INCLUDING DIRECT, INDIRECT, INCIDENTAL, CONSEQUENTIAL, LOSS OF BUSINESS PROFITS OR SPECIAL DAMAGES, EVEN IF MICROSOFT CORPORATION OR ITS SUPPLIERS HAVE BEEN ADVISED OF THE POSSIBILITY OF SUCH DAMAGES. SOME STATES DO NOT ALLOW THE EXCLUSION OR LIMITATION OF LIABILITY FOR CONSEQUENTIAL OR INCIDENTAL DAMAGES SO THE FOREGOING LIMITATION MAY NOT APPLY.

Last reviewed: September 13, 1996
©1997 Microsoft Corporation. All rights reserved. Legal Notices.