1.5. Opening Files
Opening existing files in Excel works much the same as it does in any Windows program. The only difference is that Excel gives you two different ways to get to the standard Open dialog box. Here are your options:
Note: If the Task Pane isn't currently visible, you can always choose View Task Pane from the menu.
Note: Depending on your computer settings, Windows may hide file extensions. That means that instead of seeing the Excel spreadsheet file MyCoalMiningFortune.xls, you just see the name MyCoalMiningFortune (without the .xls part on the end). In this case, you can still tell what the file type is by looking at the icon. If you see a small Excel icon next to the file name, that means Windows recognizes that the file is an Excel spreadsheet. If you see something else (like a tiny paint palette, for example), you need to make a logical guess about what type of file it is.
When you open a file or save a file for the first time, Excel starts you off in the My Documents folder. This folder is Windows-specific, as many programs assume you use Windows for all your files. If you don't use My Documents, you can tell Excel to look elsewhere when saving and opening files. To do so, select Tools Options. In the Options dialog box, click the General tab. You can modify the "Default file location text box so that it points to the folder where you usually store files (as in c:\John Smith\MyExcel Files). Sadly, you can't browse and pick the path from a dialog boxinstead, you need to type it in by hand.
There's one other interesting option in the General tab. You can use the "At startup, open all files in" text box to specify a folder where you put all the Excel files you're currently working with. Then, the next time you start Excel, it automatically opens every .xls file it finds in a separate Excel window. Of course, if you decide to use this option, make sure you don't clutter your in-progress folder with too many files, or Excel will open a dizzying number of windows when it starts.
1.5.1. Opening Multiple Spreadsheets at Once
As you open multiple spreadsheets, Excel creates a new window for each one. You can easily jump from one spreadsheet to another by clicking the appropriate spreadsheet button in the Windows taskbar at the bottom of your screen (see Figure 1-20, top).
If you're using Windows XP, you may find that your computer has an odd habit of spontaneously bunching together taskbar buttons. For example, shortly after you open three Excel files, you may find them in one taskbar button cleverly named 3 Microsoft Office Excel (see Figure 1-20, bottom).
Automatic taskbar bunching does save screen space, but it also makes it a little more awkward to get to the Excel spreadsheet you want. You now need two mouse clicks instead of one: the first to click the taskbar button, and the second to choose the window you want from the group.
Figure 1-20. Top: When you have multiple spreadsheets open at the same time, you can easily move from one to the other by clicking their file names in the taskbar (at the bottom of the screen).
|POWER USERS' CLINIC|
Excel provides an advanced search feature that gives you more control over search details, allowing you to narrow down the search results based on additional criteria, such as who created a file and when. This technique is helpful if you need to search through hundreds of files to find a match.
To use it, open the Basic Files Search task window (choose File Search), and at the bottom, click the Advanced File Search link. A similar, but slightly more complex task window appears.
Author for the Property, is for the Condition, and Samuel Dent for the Value.
Finally, click Add to include your condition in the list of search conditions. You can repeat this process to add as many different conditions as you want. When you're finished, click Go to launch the search, which switches you to the familiar Search Results task window.
You can also increase the speed of searches by indexing your files. An index is a catalog of all the files on your computer, which includes various pieces of information about each file (like who created it and when it was created). When you search indexed files, Excel can scan the index to find a match instead of chewing through your entire hard drive. Indexing speeds up the whole search process.
In order to make sure files are indexed, you need to use a special utility called the Indexing Service. To turn on the Indexing Service, open the Basic File Search task window, click the Search Options link, and then choose "Yes, enable Indexing Service". Of course, all good things come with a price, and the Indexing Service can conceivably slow down the performance of your computer (but not a lot).
To use Excel's file-search feature, follow these steps:
If you're using Excel 2003, Select File File Search. In Excel 2002, click the drop-down arrow in the Task Pane and choose the Search task.
Type the words you want to search for in the "Search text" box.
You can type in one or more words to search for. For example, you could try airline or silverware or airline silverware. Bear in mind that the more words you type in, the more specific your search and the more likely you are to find a relevant match. In addition, you can use the ? and * characters as wildcards, which are symbols that stand in for unknown text and can really enhance a search. In Excel's search, the asterisk (*) represents a group of one or more characters. For example, a search for s*nd matches documents that contain sand, sound, send, or even the bizarre series of characters sgrthdnd. The question mark (?) represents any single character. For example, f?nd matches documents that contain find or fund but not friend.
From the "Search in" drop-down list, choose the locations where you want to search.
When you expand the "Search in" list, Excel shows you a tree of drives and folders on your computer (Figure 1-22, left), which is similar (though not identical) to the tree in Windows Explorer. Expand the appropriate drives where you want to search (click them or the plus signs next to them), and choose the folders that may have the file you're looking for by clicking them. In general, a good place to search is the My Documents folder (under My Computer), which is a standard place to store documents and which tends to junk up and become Land of the Lost.
Excel gives you two ways to select a folder. Click once to place a checkmark next to the folder. This sign indicates that the search will include the selected folder, but it won't branch out to cover subfolders. Click twice to place a checkmark with multiple boxes underneath it. This icon indicates that the search will include the selected folder and all the subfolders it contains. If you expand the folder, you can see that all the subfolders now have a checkmark icon to indicate they're also included.
From the "Results should be" drop-down list, choose the types of files you want to search for.
As shown in Figure 1-22 (right), Excel distinguishes between three main categories of files: Office documents, Web pages, and Outlook items (like email messages). Usually, Excel automatically includes Web pages and common Office document formats (Word documents, spreadsheets, PowerPoint presentations, and so on) in a search. In most cases, however, you're only interested in Excel spreadsheets. Clear all the other checkboxes to speed up your search and reduce false matches.
Click Go to start the search.
The Task Pane switches to the Search Results task, which shows the current search progress and the list of results that Excel has found so far (Figure 1-23). If Excel finds no results, the search ends by displaying the message "No Results Found."
If Excel finds files, select one from the search results and open it.
If your search has turned up some results, you can open them directly from the Search Results task. Simply click the file once. If your results contain non-Excel files, when you click one, the appropriate program opens automatically.
For example, if you click a Word document, a new Word window opens with the file.
If your search turns up a large number of results, Excel doesn't show them all at once. Instead, it includes a link at the bottom of the result list indicating how many results remain to be viewed (for example, "Next 17 results"). Click this link to show the next page of results.