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

Article translations Article translations
Article ID: 286142 - View products that this article applies to.
This article was previously published under Q286142
Expand all | Collapse all

On This Page


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.

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.


Article ID: 286142 - Last Review: January 6, 2006 - Revision: 3.1
  • Microsoft Excel 2000 Standard Edition
kbhowtomaster KB286142

Give Feedback


Contact us for more help

Contact us for more help
Connect with Answer Desk for expert help.
Get more support from