Page 187 - Excel Timesaving Techniques for Dummies

36_574272 ch31.qxd 10/1/04 10:52 PM Page 172
172
Technique 31: Quickly Finding the Workbook You Want to Edit
Recently Used File List

• Figure 31-1: Check the Recently Used file list on the
Getting Started task pane for the workbook
you want to open.

Making the Most of the

File Search Task Pane
• Figure 31-2: Searching for a workbook file from the Basic
File Search task pane.
If the workbook file you want to work with is not
among the four files listed in the Recently Used file
Search Text is the text box where you enter one
list, your next line of defense is the Search feature in or more words contained in the file that you
the Open dialog box. You can access this feature
want to find. If you’re unsure of how certain
right from the worksheet window. Just use the Basic words are spelled, you can use the wildcard
File Search task pane (shown in Figure 31-2), which characters ? and * when entering the search
you can open by choosing File➪File Search. text:

The ? wildcard stands for a single character
Doing a basic file search so that entering t?m finds files that contain
The Basic File Search task pane contains the follow- Tim and Tom but not team and trim.
ing three boxes that you can use in conducting your The * wildcard character stands for any num-
file search: ber of characters so that entering t*m finds
files that contain all four words in the preced-
ing example.