Find or Replace in all sheets of the workbook:

1. From the sheet tab's shortcut menu, select Select All Sheets.

2. Press Ctrl+F to find or Ctrl+H to find and replace. (Note: Ctrl+F works only for a single sheet in Excel 97). In Excel 2002 and 2003, choose Sheet or Workbook from the within dropdown list (see the screenshot below).



Using wild cards in the text search:

Use * as a wild card for any number of characters, either before or after text, for example, searching for *CO will find both Cisco and Telco.

Use ? as a wild card for a single character, for example, searching for R?N will find Ron and Ran but not Rain.

To search for an asterisk, enter ~* in the search box.