Searching for the Right File
It happens to everyone at one time or another—you navigate to what you think is the correct folder, but you can't find a particular file. Or you know that you saved a file, but just can't remember the exact name. If you can't locate a file, don't fret. Excel can help you find what you're looking for.
The File Search feature helps you search for files saved on your local hard drive or a network drive. You can search for a file by the filename or type, or by data within the file or the file properties.
Using File Search to locate files requires a little preparation. Table 4.1 shows you search tips that help you locate the files you need.
| If You're Looking For | Type | Example |
|---|---|---|
| A phrase | “ “ | “Awards for the ... |
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.
