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

Find and Replace This Disgrace! 219
10. Click the Find All button to find all occurrences of the search string. Click the Find Next button to find just the first occurrence of the search string.
When you click Find All, Excel lists all the cells containing the search string in a list box at the bottom of the Find and Replace dialog box, as shown in Figure 3-16. You can then have Excel select the cell with a partic- ular occurrence by clicking its link in this list box. You may have to drag the Find and Replace dialog box out of the way to see the selected cell.
When you click Find Next, Excel selects the next cell in the spreadsheet (using the designated search direction). To find subsequent occurrences of the search string, you need to continue to click Find Next until you reach the cell that you’re looking for. Again, you may have to drag the Find and Replace dialog box out of the way to see the cell that Excel has located and selected in the worksheet.
11. After you finish searching the spreadsheet for the search string, click the Close button.
Figure 3-16:
Finding a value in a worksheet by using the options on the Find tab.
Note that Excel retains your search string and search option conditions even after closing the Find and Replace dialog box. To repeat a search, just press Ctrl+F and then click Find All or Find Next. You can also reinstate a search string that you used earlier in your work session by choosing it from the Find What drop-down menu.
Finding and replacing stuff
The Find feature is sufficient if all you want to do is locate an occurrence of a search string in your worksheet. Many times, however, you will also want to
Book II Chapter 3
Editing and Proofing Worksheets