How to find data in multiple Excel worksheet

Method

1. Create an excel file, create multiple excel worksheet in the other area, and enter the number 0 in each worksheet.

2. Press Ctrl + F. Enter 0 in the open input box and click search all. The result is shown in the following figure. Obviously, this is not the result we need.

 
3. Press Ctrl + F to display the search window. Click the option on the right of the window. As shown in the following figure.

4. Select a range from the drop-down list and select a workbook from the worksheet and workbook options. Click Search all.

5. The exact search result is displayed in the search box. Click the details to find the details for subsequent editing.