This frees up both time for you and space on your drive.
You have information in each worksheet, and you want to search for "computer" in Sheet1 and Sheet3. Once each worksheet you want to search is highlighted, perform a Find, and all highlighted worksheets will be searched.įor example, let's say your worksheet names are the defaults, "Sheet1," "Sheet2," and "Sheet3". Highlight each worksheet tab you want to search by holding down the Ctrl key and clicking each tab you would like to search. In addition to finding text in the entire workbook, you can individually select the worksheets to search. You can use the keyboard shortcut Ctrl+ F to open the Find and Replace box.