Search for Text in Spreadsheet Document

To search for a text in a spreadsheet document, select Edit – Find… menu item.

In the window that opens, specify the keywords and search options.

To distinguish between uppercase and lowercase letters, check Match Case.

If Whole words only is checked, the application will search for a text that matches the entered fragment completely.

Search direction:

  • Forward - the search will be performed in cells between the current cell and the end of the document.
  • Back - the search will be performed in the cells between the current cell and the beginning of the document.

View (search) results can be arranged: by column, by row, by current column, by current row.

1C:Enterprise Developer's Community