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.

In the desktop application:

In regular reports. Select the Find item in the drop-down menu of the Find and Replace button on the Home ribbon tab.
In express reports and dashboards. Select the Find item in the drop-down menu of the Find and Replace button on the Home ribbon tab.
In workbooks. Click the Find button on the Table ribbon tab.
Press CTRL+F to find data.
Press CTRL+H to replace data.

In the web application:

In regular reports and dashboards. Click the Find button on the Home ribbon tab.
In express reports. Click the Find button on the Table: Designer ribbon tab.
In workbooks. Click the Find button on the Table ribbon tab.

NOTE. Data replacement is available only in the desktop application.

Finding Data

NOTE. The default search is executed by table cell values, by rows without taking case and format of searched cells into account, and other parameters. Regular reports and data entry forms allow for additional search on a sheet by default.

NOTE. Formatting can be set up only in the desktop application.

To select the format of searched value, click the Format button. The menu with the following items opens:

Set Format. The Cell Format dialog box opens where the format of the searched value should be set. The specified format is displayed in the Sample box. If the format is not set, the box displays the "No Format Set" text.
Choose Format from Cell. It hides the Find and Replace 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 displays the "No Format Set" text.

To take the character case into account in the searched text, select the Match Case checkbox.

To find only the cells, which contain the whole value, entered in the search field, select the Whole Cell checkbox.

NOTE. Search scope can be selected only in the desktop application in regular reports and data entry forms.

To select search scope, use the Search Scope drop-down list that contains the following values:

Report.
Sheet.

To select search area, use the Search Order drop-down list containing the following values:

By Rows.
By Columns.

To select search object, use the checkboxes:

Value. Search is executed by cell values.
Text. Search is executed by text displayed in cells. The displayed text may differ from cell value due to data format settings. For example, a cell may contain the 2.5879 value and display the 2.59 text.
Formula. Search is executed by formulas, by which cell values are calculated.
Metadata. Search is executed by table cell metadata. Calculated elements are searched by their formula.
Metadata includes data source name and names of the dimension elements corresponding to this cell. In regular reports, selected cell metadata is displayed at the end of formula bar.

NOTE. The Formula and the Metadata checkboxes are available only in the desktop application.