Microsoft Office Tutorials and References
In Depth Information
One way you can use the extra options in the Find And Replace dialog box is to use
a specific format to identify data that requires review. As an example, Consolidated
Messenger VP of Marketing Craig Dewar could make corporate sales plans based on
a projected budget for the next year and mark his trial figures using a specific format.
After the executive board finalizes the numbers, he could use the Find Format capability
in the Find And Replace dialog box to locate the old values and change them by hand.
The following table summarizes the Find And Replace dialog box controls’ functions.
Find What field Contains the value you want to find or replace
Find All button Selects every cell that contains the value in the Find What field
Selects the next cell that contains the value in the Find What field
Contains the value to overwrite the value in the Find What field
Replaces every instance of the value in the Find What field with the value
in the Replace With field
Replace button Replaces the highlighted occurrence of the value in the Find What field
and highlights the next cell that contains that value
Options button Expands the Find And Replace dialog box to display additional capabilities
Format button Displays the Find Format dialog box, which you can use to specify the
format of values to be found or values to be replaced
Enables you to select whether to search the active worksheet or the entire