Articles with the tag:
Close
Changelog
Close
Try in the cloud
Try in the cloud

Use the Find and Replace function

Search for certain text

  1. tap the Settings icon Settings icon in the right corner of the top toolbar,
  2. tap the Find icon Find and replace option to activate the Find panel,

    Search panel

  3. if necessary, you can specify search parameters by tapping the Search options icon Search Options icon on the left.

    The Find and replace settings panel opens. You can adjust the following options:

    Search options panel local

    • Search in - is used to search within the active Sheet only or the whole Workbook.
    • Look through - is used to specify the direction that you want to search: to the right by rows or down by columns.
    • Search areas - is used to specify whether you want to search the Value of the cells or their underlying Formulas.
    • Case sensitive - turn on this switcher 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 - turn on this switcher 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).

    When ready, tap DONE.

  4. enter your inquiry into the data entry field,

    Search panel

  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 to open the Find and replace settings panel,
  2. tap the Find and replace menu item, change the search parameters, if necessary, and tap DONE. 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, tap the Search options icon Search Options icon on the left to open the Find and Replace settings panel, tap the Find and replace all menu item and tap DONE. Tap the Replace all caption that appears next to the entry field.

Exit the Find mode

To close the Find panel, tap the Back button on your device.

Download Teach your robot to read View and edit documents, spreadsheets
and presentations of all popular formats
You Might Also Like This:
Close