Microsoft KB Archive/286142

= HOW TO: Use Find to Search Multiple Worksheets in Excel 2000 =

Article ID: 286142

Article Last Modified on 1/6/2006

-

APPLIES TO


 * Microsoft Excel 2000 Standard Edition

-



This article was previously published under Q286142



IN THIS TASK
SUMMARY
 * Search Multiple Worksheets



SUMMARY
This step-by-step article shows you how to search for data in more than one sheet in a workbook without searching each sheet individually. This is helpful if you want to find data and do not know which sheet the data is on.

back to the top

Search Multiple Worksheets
To search multiple worksheets, follow these steps:
 * 1) Select the worksheets that you want to search by holding down the SHIFT key and clicking the worksheet tabs.
 * 2) On the Edit menu, click Find.
 * 3) In the Find what box, type the data that you are searching for, and then click Find Next.

back to the top

Additional query words: XL2000

Keywords: kbhowtomaster KB286142

-

[mailto:TECHNET@MICROSOFT.COM Send feedback to Microsoft]

© Microsoft Corporation. All rights reserved.