Microsoft Office Tutorials and References
In Depth Information
Finding and replacing data
2
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 by 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.
Control
Function
Find What field
Contains the value you want to find or replace
Find All button
Identifies every cell that contains the value in the Find What field
Find Next button
Selects the next cell that contains the value in the Find What field
Replace With field
Contains the value to overwrite the value in the Find What field
Replace All button
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
Opens the Find Format dialog box, which you can use to specify the
format of values to be found or values to be replaced
Within box
Enables you to select whether to search the active worksheet or the
entire workbook
Search box
Enables you to select whether to search by rows or by columns
Look In box
Enables you to select whether to search cell formulas or values
Search JabSto ::




Custom Search