Searching Data

Home > Edit > Find & Select > Find

 

 

You can search for data in any of the cells in the DataBook by specifying the string of data for which to search.

 

Dialog box items

Search what:
Specify the number or text you wish to search for.

Match case:
When determining matches, consider the case.

Find entire cells only:
When determining matches the number or text string in the Find what box must match the entire displayed cell in the worksheet.

Alternate search (down then across):
Set the search to move by alternate coordinates of column, row (instead of row, column).

Use wildcards:
Set the search to consider wildcard characters (*, ?) in the search string.

Find:
Click to find the next occurrence of the string that is in the Find what text box.

Close:
Click to close the dialog box and end the Find.