Articles with the tag:
Close
Changelog
Close

Use the Find and Replace function

Search for certain text

  1. tap the Find icon Search icon at the top toolbar to activate the Find panel,

    Search panel

  2. enter your inquiry into the data entry field,
  3. specify search parameters by tapping the Search options icon Search Options icon on the left and selecting the necessary options:
    • SEARCH IN - is used to search within the active Sheet only or the whole Workbook.
    • Match Case - is used to find only the occurrences typed in the same case as your inquiry (e.g. if your inquiry is 'Editor' and this option is enabled, such words as 'editor' or 'EDITOR' etc. will not be found).
    • Match Cell - is used to find only the cells that do not contain any other characters besides the ones specified in your inquiry (e.g. if your inquiry is '56' and this option is enabled, the cells containing such data as '0.56' or '156' etc. will not be found).
  4. tap the Search caption next to the entry field - the first cell that contains the required characters will be selected,
  5. use arrow buttons to navigate through the found occurrences towards the beginning of the worksheet (if you tap the Left arrow button icon) or towards the end of the worksheet (if you tap the Right arrow button icon) from the current position.

Replace the found matches

  1. tap the Search options icon Search Options icon on the left,
  2. tap the Find and Replace menu item - the Find panel will change,

    Find and Replace panel

  3. enter the replacement text into the second data entry field,
  4. use arrow buttons to navigate through the found occurrences and tap Replace to replace the currently selected occurrence,
  5. to replace all the found occurrences, hold the Replace caption next to the entry field until the menu with the Replace All option appears, then tap it.

Exit the Find mode

To close the Find panel, tap within the worksheet area.

Power up your iOS Create, edit and view documents, spreadsheets
and presentations of all popular formats
You Might Also Like This:
Close