Microsoft Office Tutorials and References
In Depth Information
Specifying variables using wildcard characters
Figure 8-41 You can find and replace character strings and formats by clicking the Replace
command on the Find & Select menu.
The expanding dialog box
The Find And Replace dialog box does a neat trick. After you execute a search, the
dialog box expands to list all the cells with contents that match your criteria:
When you select an entry in the list, Excel jumps to that location and selects the cell.
You can drag the bottom border of the dialog box to see more of the list. This feature
makes it much easier to do extensive find-and-replace tasks because you can see the
list at all times; because items remain in the list even after you execute a replacement
operation; and because you can keep the dialog box open, change worksheets or
workbooks, and use the Undo button while you work.