Find and Replace

Use find and replace if required.

Find

To find data in data entry form, select the Find > Find item on the Home ribbon tab. The Find and Replace dialog box opens. In the Find box of the Find tab enter the searched values, formulas or text or select the searched data used before in the drop-down list. If required, determine advanced search parameters by clicking the More Parameters button:

Format. To select search value format, use drop-down menu of the Format button containing the following commands:

Specify Format. Opens a standard formatting dialog box where the required format is set. Custom format is displayed in the Sample box. If no format is set, the box shows No Format Set.
Choose Format from Cell. It hides a dialog box. After the report cell is selected, the dialog box is displayed again, the Sample box displays format of the selected cell.
Clear Find Format. It resets the selected format. The Sample box shows No Format Set.

Match Case. It indicates whether the case is to be matched during text search.
Whole Cell. To find cells that contains the whole value entered for the search.
Search Scope. To select search scope. The drop-down list contains values: on the sheet, in the report.
Search Order. To select search order. The drop-down list contains values: by rows, by columns.
Search Object. To select search object, use the Text or Formula checkboxes.

Replace

To replace data in a data entry form, select the Find > Replace item on the Home ribbon tab. The Find and Replace dialog box opens. In the Find box of the Replace tab enter the searched values, formulas or text or select the searched data used before in the drop-down list.

In the Replace With box enter values, formulas or text to replace the initial value with.

If required, determine advanced search parameters.

Click the Replace button for step-by-step replacing data in table cells or the Replace All button to replace all values.

When find and replace are finished, follow the step if required: