Contents

# Find & Replace

Finds or replaces text or formats in the current document.

Để truy cập lệnh này...

#### From the menu bar:

Choose Edit - Find & Replace.

#### From toolbars:

Find & Replace

#### From the keyboard:

Command Ctrl + H

## 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".

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).

### Formatted display

Includes number formatting characters in the search.

### Entire Cells Whole words only

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

### All sheets

Searches through all of the sheets in the current spreadsheet file.

## Replace

Nhập chuỗi thay thế, hoặc chọn một chuỗi thay thế vừa dùng trong danh sách.

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

## Tìm tất cả

Tìm và lựa chọn mọi lần gặp đoạn văn hay định dạng bạn tìm kiếm trong tài liệu (chỉ trong tài liệu kiểu Writer và Calc).

## 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.

## Thay thế

Thay thế đoạn hay định dạng bạn đã tìm kiếm, sau đó tìm kiếm lần gặp kế tiếp.

## Thay thế tất cả

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.

### Chú thích

Trong Writer, bạn có thể lựa chọn để bao gồm ghi chú trong những tìm kiếm của bạn.

### Wildcards

Allows you to search for advanced patterns using meta characters.

Using wildcards

### Regular expressions

Allows you to search for advanced text patterns using regular expressions.

Danh sách Biểu thức Chính quy

### Paragraph Styles / Including Styles

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.

### Cell Styles

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.

### Khớp bề rộng ký tự (chỉ nếu cũng hiệu lực các ngôn ngữ Châu Á).

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

### Nghe như (tiếng Nhật) (chỉ nếu cũng hiệu lực các ngôn ngữ Châu Á).

Cho phép bạn ghi rõ các tùy chọn tìm kiếm về kiểu ghi tương tự được dùng trong văn bản tiếng Nhật. Bật tùy chọn này, sau đó nhấn vào nút ... để ghi rõ các tùy chọn tìm kiếm.

Tìm bằng tiếng Nhật

### 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.

## Attributes

Choose the text attributes that you want to search for. For example, if you select the Outline attribute, then all characters formatted manually with an Outline effect are found. If you also want to find characters with an Outline effect as part of a style, then select Including styles in the Other Options section, before searching.

Searching for Attributes

## Format

Tìm các tính năng định dạng văn bản dứt khoát, v.d. kiểu phông, hiệu ứng phông và đặc tính luồng văn bản.

After you select format and attributes that you want to search for, the Paragraph Styles checkbox in the Other options area changes to Including Styles. Select this checkbox if you want to include search for formatting and attributes set by styles.

## No Format

Click in the Find or the Replace box, and then click this button to remove the search criteria based on formats.

The search and replace criteria selected for Format and Attributes are displayed under the Find and Replace boxes.

## Direction

Determines the order for searching the cells.

### Rows

Searches from left to right across the rows.

### Columns

Searches from top to bottom through the columns.

## Search in

### Formulas

Searches for the characters that you specify in formulas and in fixed (not calculated) values. For example, you could look for formulas that contain 'SUM'.

### Values

Searches for the characters that you specify in values and in the results of formulas.

### Comments

Searches for the characters that you specify in the comments that are attached to the cells.

### Đóng

Đóng hộp thoại và lưu các thay đổi đã làm.

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

Chủ đề Liên quan

Using Wildcards in Formulas

Using Regular Expressions in Text Searches

Danh sách Biểu thức Chính quy

Tìm và Thay thế trong Writer

Please support us!