Page 238 - Excel 2013 All-in-One For Dummies

220 Find and Replace This Disgrace!
change some or all of the cells that match the search string. For those situa- tions, you use the Replace feature to locate the search string and replace it with some other string.
To search and replace information in your worksheet, follow these steps:
1. To search and replace the entire worksheet, select a single cell. To restrict the search and replace operation to a specific cell, range, or nonadjacent selection, select all the cells to be searched.
2. Choose the Replace option from the Find & Select button’s drop-down menu on the Ribbon’s Home tab or press Ctrl+H.
Excel opens the Find and Replace dialog box with the Replace tab selected (similar to the one shown in Figure 3-17). Note that if the Find and Replace dialog box is already open from choosing the Find option from the Find & Select button’s drop-down menu or pressing Ctrl+F, all you have to do is click the Replace tab.
3. Type the search string that you want to locate in the Find What combo box and specify any formatting to be searched by using its Format button.
Refer to the previous steps on finding a search string for details on spec- ifying the search string in the Find What combo box and specifying the formatting to be searched for.
4. Type the replacement string in the Replace With combo box.
Enter this string exactly as you want it to appear in the cells of the work- sheet. Use uppercase letters where uppercase is to appear, lowercase letters where lowercase is to appear, and the question mark and asterisk only where they are to appear. (They don’t act as wildcard characters in a replacement string.)
5. Click the Options button and then click the Format drop-down button and choose Format to select the formatting to be added to your replacement string from the Find Format dialog box. Or click Choose Format from Cell and select the formatting directly from a cell in the worksheet.
When you click the Format item, Excel opens a Find Format dialog box with the same tabs and options as the standard Format Cells dialog box. You may then select the formatting that you want the replacement string to have in this dialog box and then click OK.
When you choose the Choose Format from Cell item on the Format button drop-down menu, the Find and Replace dialog box temporarily disappears until you click the cell in the worksheet that contains the formatting that you want the replacement string to have with the thick, white-cross mouse pointer with eyedropper icon.