Finding and replacing information in the Viewer

  1. To find or replace information in the Viewer, from the menus choose:

    Edit > Find

    or

    Edit > Replace

You can use Find and Replace to:

  • Search the entire document or just the selected items.
  • Search down or up from the current location.
  • Search both panes or restrict the search to the contents or outline pane.
  • Search for hidden items. These include any items hidden in the contents pane (for example, Notes tables, which are hidden by default) and hidden rows and columns in pivot tables.
  • Restrict the search criteria to case-sensitive matches.
  • Restrict the search criteria in pivot tables to matches of the entire cell contents.
  • Restrict the search criteria in pivot tables to footnote markers only. This option is not available if the selection in the Viewer includes anything other than pivot tables.

Hidden Items and Pivot Table Layers

  • Layers beneath the currently visible layer of a multidimensional pivot table are not considered hidden and will be included in the search area even when hidden items are not included in the search.
  • Hidden items include hidden items in the contents pane (items with closed book icons in the outline pane or included within collapsed blocks of the outline pane) and rows and columns in pivot tables either hidden by default (for example, empty rows and columns are hidden by default) or manually hidden by editing the table and selectively hiding specific rows or columns. Hidden items are only included in the search if you explicitly select Include hidden items.
  • In both cases, the hidden or nonvisible element that contains the search text or value is displayed when it is found, but the item is returned to its original state afterward.

Finding a range of values in pivot tables

To find values that fall within a specified range of values in pivot tables:

  1. Activate a pivot table or select one or more pivot tables in the Viewer. Make sure that only pivot tables are selected. If any other objects are selected, the Range option is not available.
  2. From the menus choose:

    Edit > Find

  3. Click the Range tab.
  4. Select the type of range: Between, Greater than or equal to, or Less than or equal to.
  5. Select the value or values that define the range.
  • If either value contains non-numeric characters, both values are treated as strings.
  • If both values are numbers, only numeric values are searched.
  • You cannot use the Range tab to replace values.

This feature is not available for legacy tables. See the topic Legacy tables for more information.