Find and replace operations for Excel

Finding and replacing is an operation that is often performed during editing, and in Excel, in addition to finding and replacing text, you can find and replace formulas and notes, which are more widely used and further improve the efficiency of editing processing. With these features, we can quickly find cells that have special characters in all worksheets except the Visual Basic module. We can replace existing characters with another string of characters in all cells in a worksheet, in one selection on a worksheet, or in the current selection of a worksheet or worksheet group. You can also find and select cells that have similar content.

5.6.1 Lookup Command

When you need to review or modify portions of a worksheet, you can find and replace any specified values, including text, numbers, dates, or find a formula, a note. For example, we can specify that Excel finds only special text with some uppercase format. For example, you can look for "green" instead of looking for "green".

To perform a lookup operation, follow these steps:

(1) Perform the "Find" command on the Edit menu, and the screen displays a dialog box, as shown in Figure 5-18.

(2) In the Find What box, enter the string you want to find, and then specify the search by and search scopes, and then press the Find Next button to start looking for work.

(3) When Excel finds a matching content, the cell pointer points to the cell. Then we can decide what to do next, and if we need to find it further, we can select and press the "Find Next" button, or you can choose the "Close" button to exit the Lookup dialog box.

Tip: You can enter up to 255 English characters (one Chinese character equals two letters) in the search target. Because the lookup target box can display a few words, when we enter a string that exceeds its display range, Excel automatically scrolls the string to display the data over the range. We can also scroll the string by moving the cursor.

Excel also provides a lookup of formulas and notes.

Tip: If you want to perform a find or replace work on a worksheet, you can select it as a worksheet group before you perform the appropriate action.