Use find and replace if required.
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:
Set Format. A standard formatting dialog box opens where the required format can be set. Custom format is displayed in the Sample box. If no format is set, the box shows No Format Set.
Choose Format from Cell. The dialog box is hidden. After the report cell is selected, the dialog box is displayed again, the Sample box displays format of the selected cell.
Clear Find Format. The selected format is reset. The Sample box shows No Format Set.
Match Case. Indicates whether the case is to be matched during text search.
Whole Cell. To find cells that contain the full 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.
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:
See also: