How can we help you?
If the document is opened in the View mode, only data search (without replacement) is available.

To open the pane to find and replace data in a document, do one of the following:

In the Command menu, select Edit > 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 based on uppercase and lowercase letters in the text you are looking for.

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). Check the box Match case when replacing 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 field, enter the data to search for.

2.Click the side_panel_search_find button 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.

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

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 the Replace button to replace the highlighted match.

Click the Replace All button to replace all matches found simultaneously.

You cannot replace a part of the found value or a part of the found result of a formula 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
No
Previous
Check spelling
Next
Delete data