| ● | Scroll the toolbar by one page (using a swipe gesture) to access this feature |
Office2 lets you search cell values and formulas for instances of specific text characters. To search cell values or formulas for occurrences of text, press the Search button in the toolbar.
The Search dialog box will appear. You can enter the search text into the top field. You can choose whether to search for cells containing, beginning with or ending with your search text. You can choose whether to search the cell value AND formula, or the value only or the formula only. You can also choose whether or not the search should consider the case sensitivity of the search text.
When you have chosen the relevant options, press the Search button. Office2 will scroll to the first cell matching your search criteria. The toolbar will change to show a Next button and a Cancel button. Pressing the Next button will scroll to the next matching cell. When you are finished, press the Cancel button.