With Excel's Find command, you can locate specific data, text, characters, formatting, and special characters . For example, what if you want to find the row that contains sales data for any category with the word cover in it. You can search for data in three ways:
In the next To Do exercise, you search for the first instance of the word cover . To Do: Find Data
To find all instances of the data, click the Find All button. At the bottom of the Find dialog box, Excel displays a list of the cells found, as shown in Figure 8.13. You should see six columns in the list: Book, Sheet, Name , Cell, Value, and Formula. The Book, Sheet, and Cell columns indicate the location of the cell. If there is a name or formula associated with the cell, you will see them in the Name and Formula columns. The data you entered in the Find What box should match the data in the Value column. Figure 8.13. The Find and Replace dialog box with a list of all cells found.
|