Find All found all 39 instances of Sir Rodney's Scones in the worksheet.
Say that you've entered the same data in different cells throughout a worksheet and you need to find each instance. Perhaps it's a person's name, a product name, or a chemical symbol. In the picture, it's Sir Rodney's Scones.
Click Find on the Edit menu, or press CTRL+F. Type what you want to find in the Find what box, which in this case is Sir Rodney's Scones. Then click Find All.
The result is a list of all 39 occurrences of Sir Rodney's Scones on the worksheet. (You can also search the entire workbook if you wish.) If you want to go to a specific occurrence of Sir Rodney's Scones in the worksheet, click an entry in the list, and the insertion point goes right to the specific cell in the worksheet.
Another way to use Find All is with special formatting. You might format cells of particular interest to you throughout a worksheet with particular formatting. Say that you make some cells bold or red so that you can easily spot them throughout your worksheet.
You can use Find All to quickly navigate to those cells again. Press CTRL+F, click the Options button, and then click the Format button. On the Format tab, select the formatting that you previously applied, and then click Find All. Now you can skip around the sheet to find all the cells that you specially formatted. If you want to reformat those cells another way, say back to regular formatting, you can use Find All to do that as well. You'll see how in the practice session.
