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 ...|