Finding/Finding & Replacing in a Single Sheet or in Entire Workbook in Excel 2007

To find or find & replace in a single sheet:

To search for text, use the keyboard shortcut Ctrl+F or Ctrl+H
Or
Select Home -> Find & Select (in Editing Group) -> Find or Replace.

To find or find & replace in all sheets of the workbook:

1. From the sheet tabs shortcut menu, select Select All Sheets.
2. Press Ctrl+F to find or Ctrl+H to find and replace.
3. In Find and Replace dialog box click Options button, select Sheet or Workbook from the Within dropdown list (see screenshot below).

To find/find and replace special characters & formats:

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 a wild card for a single character, for example, searching for RN will find Ron and Ran but not Rain.
To search for an asterisk, enter ~* in the search box.

Screenshot // Finding/Finding & Replacing in a Single Sheet or in Entire Workbook in Excel 2007
Finding/Finding & Replacing in a Single Sheet or in Entire Workbook in Excel 2007Finding/Finding & Replacing in a Single Sheet or in Entire Workbook in Excel 2007

Leave a Reply

Your email address will not be published. Required fields are marked *

You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <strike> <strong>

Terms and Conditions of use

The applications/code on this site are distributed as is and without warranties or liability. In no event shall the owner of the copyrights, or the authors of the applications/code be liable for any loss of profit, any problems or any damage resulting from the use or evaluation of the applications/code.

Visit Us On TwitterVisit Us On FacebookVisit Us On Google PlusVisit Us On Youtube