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.
- Open the report you want to find content in.
- Click the Home tab.
- Click Find.
The Find window opens.
- Enter the search value you want to find in the report in
the Find Text field.
- To highlight cells in the report only if the content matches
the case you use in the search value, select Match Case.
- 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.
- 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.
- To find the next instance of the search value without opening
the Find window, click Find on the Home tab.
- To clear the search value you entered without opening the
Find window, click Clear on the Home tab.