Home 
Excel Find Using Find And Replace In An Entire Excel Workbook
Search MS Office A-Z | Search Web Pages/ Design A-Z
Using Find And Replace In An Entire Excel Workbook
To tell Find and Replace Excel to search more than one sheet, click the tab of the first sheet, then hold down Ctrl and click the tab of each of the remaining sheets you want to include in the search. You can now press Ctrl/H to open the Replace dialog box.