Excel 简明教程

Find & Replace in Excel 2010

MS Excel 提供了 Find & Replace 选项，用于在工作表中查找文本。

MS Excel provides Find & Replace option for finding text within the sheet.

Find and Replace Dialogue

让我们看看如何访问查找和替换对话框。

Let us see how to access the Find & Replace Dialogue.

要访问查找和替换，请选择 Home → Find & Select → Find 或按 Control + F Key 。请参见下图。

To access the Find & Replace, Choose Home → Find & Select → Find or press Control + F Key. See the image below.

find option

你可以在 Find and Replace dialogue 中看到如下内容。

You can see the Find and Replace dialogue as below.

find tab

你可以在 Replace tab 中用新文本替换找到的文本。

You can replace the found text with the new text in the Replace tab.

replace tab

Exploring Options

现在，我们来看看“查找”对话框中提供的各种选项。

Now, let us see the various options available under the Find dialogue.

  1. Within − Specifying the search should be in Sheet or workbook.

  2. Search By − Specifying the internal search method by rows or by columns.

  3. Look In − If you want to find text in formula as well, then select this option.

  4. Match Case − If you want to match the case like lower case or upper case of words, then check this option.

  5. Match Entire Cell Content − If you want the exact match of the word with cell, then check this option.

various find options