Finding Data
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:
Find the first occurrences of the data
Find other occurrences of that data
Find all occurrences of that data
In the next To Do exercise, you search for the first instance of the word cover.
To Do: Find Data
1. | Choose Edit, Find. Excel opens the Find and Replace dialog box. | ||
2. | Click the Find tab, if necessary.
|
Get Sams Teach Yourself Microsoft® Office Excel 2003 in 24 Hours now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.