XL: Find Command Doesn't Work Across Worksheets in Group

• Microsoft Excel for Windows, version 5.0c
• Microsoft Excel for Windows 95, versions 7.0, 7.0a
• Microsoft Excel 97 for Windows
• Microsoft Excel for the Macintosh, versions 5.0, 5.0a
• Microsoft Excel 98 Macintosh Edition
• Microsoft Excel for Windows NT, version 5.0

SYMPTOMS

When you use the Find dialog box to locate specific information, Microsoft Excel finds only the first occurrence of the value (even if you have selected multiple worksheets that contain this information).

CAUSE

This behavior occurs because the Find command does not work across grouped worksheets. Microsoft Excel Help states that if a group of sheets is selected, the Find command searches all of the sheets in the group except Visual Basic modules. This is not the actual behavior. When you select multiple worksheets, and you use the Find command to search for information on a worksheet, only the first occurrence of the value is selected.

Note that if the information is not located on the active worksheet, even if it is located on another sheet in the group, you receive the following error message:

   Cannot find matching data

      command exhibits this behavior.

REFERENCES

Microsoft Excel 97

For more information about the Find command on the Edit menu, click the Index tab in Microsoft Excel Help, type the following text

   Finding, data

Microsoft Excel 5.0

For more information about the Find Command (on the Edit Menu), choose the Search button in Help and type:

   Find Command (Edit Menu)