Microsoft Office Tutorials and References
In Depth Information
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
When checked, requires that all matches have the same capitalization as
the text in the Find What field (for example, cat doesn’t match Cat )
Requires that the cell contain exactly the same value as in the Find What
field (for example, Cat doesn’t match Catherine )
Closes the Find And Replace dialog box
To change a value by hand, select the cell, and then either type a new value in the cell or,
in the formula bar, select the value you want to replace and type 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 with a particular formatting.
SET UP You need the AverageDeliveries_start workbook located in your Chapter02
practice file folder to complete this exercise. Open the AverageDeliveries_start
workbook, and save it as AverageDeliveries . Then follow the steps.
1. If necessary, click the Time Summary sheet tab.
The Time Summary worksheet is displayed.
2. On the Home tab, in the Editing group, click Find & Select , and then click Find .
The Find And Replace dialog box opens with the Find tab displayed.
Keyboard Shortcut Press Ctrl+F to display the Find tab of the Find And Replace
3. In the Find what field, type 114 .
4. Click Find Next .