Find Content in a Report

You can search for specific text, numeric values, or special characters in the content displayed in a report using the Find feature.

When using the Find feature, cells on the report page currently being viewed that contain what you searched for are highlighted. Content on other pages or drill-down levels in the report must be searched separately.
  1. Open the report you want to find content in.
  2. Click the Home tab.
  3. Click Find.
    The Find window opens.
  4. Enter the search value you want to find in the report in the Find Text field.
  5. To highlight cells in the report only if the content matches the case you use in the search value, select Match Case.
  6. To highlight cells in the report only if the cell content exactly matches the search value you enter in the Find Text field, select Match Entire Cell Contents.
  7. Do one of the following:
    • Click Find Next to close the Find window and highlight the first cell in the report that matches the search value you entered.
    • Click Find All to close the Find window and highlight all the cells in the report that match the search value you entered.
  8. To find the next instance of the search value without opening the Find window, click Find on the Home tab.
  9. To clear the search value you entered without opening the Find window, click Clear on the Home tab.