![]() Now you can work with the search results: ![]() Replace, select, or export the found entries When you are finished with the settings, click the Find All button. Click the Options icon to select the shortcut you want to use to start the add-in:.Tick the boxes near the workbooks and worksheets you want to scan.if you select this option with the value 'Robert', you'll find only those cells that don't contain any other values. Check the Entire cell box to search for an exact and complete match of the characters specified in the top field.For example, to find the name "Robert" and exclude entries like enter "Robert" into the field at the top, check the Match case box, and you'll see all entries that begin with an uppercase letter. If you want to distinguish between uppercase and lowercase characters, select Match case.The Match options section adds certain flexibility to defining the values to look for:.You can tick all these boxes to perform search in all types of records at the same time. Decide if the add-in should go through Values, Formulas, Comments, Hyperlinks, and/or Errors and check the needed option(s).You can specify the search option right away by clicking the down arrow below the add-in's icon and picking the necessary option from the drop-down menu:
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |