Microsoft Office Tutorials and References
In Depth Information
Finding and replacing data
Control
Function
Match Case check box
When selected, requires that all matches have the same
capitalization as the text in the Find What field (for example, cat doesn’t
match Cat)
Match Entire Cell Contents
check box
Requires that the cell contain exactly the same value as in the Find
What field (for example, Cat doesn’t match Catherine)
Close button
Closes the Find And Replace dialog box
To change a value by hand, select the cell, and then either enter a new value in the cell or,
in the formula bar, select the value you want to replace and enter the new value. You can
also double-click a cell and edit its contents within the cell.
In this exercise, you’ll find a specific value in a worksheet, replace every occurrence of a
company name in a worksheet, and find a cell that has a specific formatting.
SET UP You need the AverageDeliveries workbook located in the Chapter02 practice
file folder to complete this exercise. Open the workbook, and then follow the steps.
1
If necessary, click the Time Summary sheet tab to display the Time Summary
worksheet.
2
On the Home tab, in the Editing group, click Find & Select , and then click Find to
display the Find page of the Find and Replace dialog box.
KEYBOARD SHORTCUT Press Ctrl+F to display the Find page of the Find And Replace
dialog box.
3
In the Find what field, enter 103 .
4
Click Find Next to have Excel select cell B5 , which contains the value 103 .
Search JabSto ::




Custom Search