Find & Replace
Searches for or replaces text or formats in the current document.
Choose Edit - Find & Replace
Ctrl+H
On Standard bar, click
Find & Replace |
Search For
Enter the text that you want to search for, or select a previous search from the list.
Search options are listed in the Options area of the dialog
Replace With
Enter the replacement text, or select a recent replacement text or style from the list.
Replacement options are listed in the Options area of the dialog.
Options
When in Calc: Entire CellsWhole words only
Searches for whole words or cells that are identical to the search text.
Backwards
Search starts at the current cursor position and goes backwards to the beginning of the file.
Regular expressions
Allows you to use wildcards in your search.
Match case
Distinguishes between uppercase and lowercase characters.
Current selection only
Searches only the selected text or cells.
Search for Styles / Including Styles
Searches for text formatted with the style that you specify. Select this checkbox, and then select a style from the Search for list. To specify a replacement style, select a style from the Replace with list.
![]() |
After you select the attributes that you want to search for, the Search for Styles box in the Options area of the LibreOffice Writer Find & Replace dialog changes to Including Styles. |
![]() |
If you want to search for text in which attributes were set by using direct formatting and styles, select the Including Styles box. |
Comments
In Writer, you can select to include the comment texts in your searches.
Similarity Search
Find terms that are similar to the Search for text. Select this checkbox, and then click the ... 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 ... button to specify the search options.
Find All
Finds and selects all instances of the text or the format that you are searching for in the document (only in Writer and Calc documents).
Find
Finds and selects the next occurrence of the text or format that you searching for in the document.
Replace All
Replaces all of the occurrences of the text or format that you want to replace.When in Impress: Repeat this command until all replacements on your slide have been made.
Replace
Replaces the selected text or format that you searched for, and then searches for the next occurrence.
When in Writer: Attribute
When in Writer: Choose the text attributes that you want to search for. For example, if you search for the Font attribute, all instances of text that do not use the default font are found. All text that has a directly coded font attribute, and all text where a style switches the font attribute, are found.
When in Writer: Format
When in Writer: Finds specific text formatting features, such as font types, font effects, and text flow characteristics.
When in Writer: No Format
When in Writer: Click in the Search for or the Replace with box, and then click this button to remove the search criteria based on formats.
When in Writer:
![]() |
The search criteria for formatting attributes are displayed under the Search for or the Replace with box. |
When in Calc: Search in
When in Calc: Formulas
When in Calc: Values
When in Calc: Searches for the characters that you specify in values and in the results of formulas.
When in Calc: Comments
When in Calc: Searches for the characters that you specify in the comments that are attached to the cells.
When in Calc: Search direction
When in Calc: Determines the order for searching the cells.
When in Calc: By Rows
When in Calc: By Columns
When in Calc: Searches from top to bottom through the columns.
When in Calc: Extras
When in Calc: Search in all sheets
When in Calc: Searches through all of the sheets in the current spreadsheet file.
Close
Closes the dialog and saves all changes.
![]() |
After you close the Find & Replace dialog, you can still search using the last search criteria that you entered, by pressing Shift+Ctrl+F. |
Related Topics
Using Wildcards in Text Searches
Finding and Replacing in Writer