Find and replace

Product:

Application: Table Home Edition macOS

If the document is opened in the View mode, you can only search for data in the document (without replacement).

To open the Find and Replace pane in a document, do one of the following:

•In the Edit menu, select Find.

•On the Sidebar, click side_panel_search Find and Replace.

•Press command_grey Cmd+F.

In the Find and Replace pane, specify the parameters for searching and replacing data:

1.Specify the data Search area:

•Current sheet: Perform a search on the currently open sheet.

•All Sheets: Perform a search through all sheets of the document.

2.If necessary, check the required Filters:

•Match whole words only: Find only whole words/values, not data that is part of other words/values.

•Match case when searching: Perform the search taking into account uppercase and lowercase letters in the searched text.

•Match case when replacing: Perform the replacement taking into account the uppercase and lowercase letters in the found text. Example: You need to replace the word agreement with the word contract in the text of the document. In this case, the word agreement can be written with both lowercase and uppercase letters (for example, at the beginning of a sentence). Select the Match case when replacing check box so that the word agreement with a lowercase letter is replaced by the word contract with a lowercase letter, and the word Agreement with a capital letter is replaced by the word Contract with a capital letter.

Case is taken into account only for the first character in the found word.

To find the data in the document, follow these steps:

1.In the Find bar, enter the data to search for.

2.Click side_panel_search_find or press enter Enter.

The matches found will be highlighted in the document.

Use the search_sidetab_nav buttons below the search and replace bars to navigate through the cells with matches found. The selected match will be highlighted in the document with a contrasting yellow color.

Search parameters can be changed while you are working with matches. The search results are updated automatically.

You can also navigate the Find and Replace pane using the keyboard as follows:

•Press tab_symbol Tab to move to the next item in the pane.

•To return to the previous pane item, press Shift+Tab.

•To activate a control (click a button, select a check box), press Space.

To replace matches found in the document, follow the steps below:

1.In the Replace with bar, enter the data to replace or leave the field blank if you want to delete the found match.

2.Replace the matches with one of the following methods:

•Click Replace to replace the highlighted match.

•Click Replace All to replace all matches found simultaneously.

You cannot replace a part of the found value or a part of the found result of a function calculation. The value or the result of a formula calculation can only be replaced in its entirety.

To close the Find and Replace pane, do one of the following:

•At the top of the pane, click side_panel_search_close .

•On the Sidebar, click side_panel_search Find and Replace.

•Press Esc.

Was this helpful?

Yes