Find and Replace

To find and replace data, use the Find and Replace dialog box. If one cell is selected, data search and replacement involves the entire table. If a cell range is selected, data is searched and replaced only in the selected cell range.

To open the Find and Replace dialog box

Finding Data

To find data:

  1. Open the Find and Replace dialog box and go to the Find tab.

  1. Enter the value, formula or text in the Find box.

  2. If required, set advanced search parameters. To do this, click the More Parameters button. Advanced search parameters appear on the Find tab:

NOTE. Default search is executed in the entire report by rows, without accounting the format of searched cells and other parameters. Search is executed by value in the table cells.

Format cells with searched values

Match case

Whole cell

Search scope

Search order

Search object

  1. Click the Find or Find Next button to consequently navigate through the found table cells, or the Find All button to display all search results:

NOTE. The Find All item is available only in the desktop application.

Find and Replace

NOTE. Data can be replaced in table only in the desktop application.

To replace data:

  1. Open the Find and Replace dialog box and go to the Replace tab.

  1. Enter values, formulas or text to search in the table, in the Find box.

  2. Enter values, formulas or text, which should substitute the searched value in the table in the Replace With box.

  3. If required, set advanced search parameters.

  4. Click the Replace button for consequent replacing of data in the table cells, or the Replace All button to replace all found values.

To stop replacing press the ESC key.

See also:

Working with Table Data