Find & Replace

Finds or replaces text or formats in the current document.

To access this command...

Choose Edit - Find & Replace.

+H

On the Standard bar, click

Icon

Find & Replace


Find

Enter the text that you want to find, or select a previous search from the list.

Search options are listed under the Find box and in the Other options area of the dialog.

Match case

Matches the exact character provided in the Find box without considering any alternative case matches.

Disable this option to consider all possible case matches. For example, entering "a" in the Find box matches both "a" and "A".

note

Be aware that some characters may have more than one match when Match case is disabled. For instance, "s" matches "s", "S" and "ß" (sharp S used in the German language).


Searches for whole words or cells that are identical to the search text.

Replace

Enter the replacement text, or select a recent replacement text or style from the list.

Replacement options are listed under the Find box and in the Other options area of the dialog.

Find Previous

Finds and selects the previous occurrence of the text or format that you are searching for in the document.

Find Next

Finds and selects the next occurrence of the text or format that you are searching for in the document.

Replace

Replaces the selected text or format that you searched for, and then searches for the next occurrence.

Replace All

Replaces all of the occurrences of the text or format that you want to replace.

Other options

Shows more or fewer search options. Click this label again to hide the extended search options.

Current selection only

Searches only the selected text or cells.

Replace backwards

Search starts at the current cursor position and goes backwards to the beginning of the file.

Searches for text formatted with the style that you specify. Select this checkbox, and then select a style from the Find list. To specify a replacement style, select a style from the Replace list.

Similarity Search

Find terms that are similar to the Find text. Select this checkbox, and then click the Similarities button to define the similarity options.

Match character width (only if Asian languages are enabled)

Distinguishes between half-width and full-width character forms.

Sounds like (Japanese) (only if Asian languages are enabled)

Lets you specify the search options for similar notation used in Japanese text. Select this checkbox, and then click the Sounds button to specify the search options.

Searching in Japanese

Diacritic-sensitive

Searches exact match, does not include Unicode combining marks in search. For example, searching for كتب will not match كَتَبَ or كُتُب or كتِب and so on.

Kashida-sensitive

Searches exact match, does not include Arabic Tatweel mark U+0640 (also known as Kashida) in search. For example, searching for كتاب will not match كـتاب or كتــــاب and so on.

Close

Closes the dialog and saves all changes.

tip

After you close the Find & Replace dialog, you can still search using the last search criteria that you entered, by pressing Shift++F.


Please support us!