Opening a Saved Workbook
Whenever you want to work on a particular workbook that you (or someone else) has already created and saved, you must open it in Excel. Assuming the workbook file is stored in the My Documents folder, finding and opening the workbook file is easy:
Open Excel's File menu and click Open or click the Open button in the Standard toolbar. The Open dialog box appears, displaying the names of all Excel workbook files in the My Documents folder, as shown in Figure 3.8.
Click the name of the Excel workbook file you want to open.
Click the Open button.
Figure 3.8 You must open a workbook file to use it.
Excel keeps track of the four most recently opened workbooks and lists them at the bottom of the File menu. To open a workbook you have recently worked on, open Excel's File menu and click the workbook's name. Or, open the Windows Start menu, point to My Recent Documents (in Windows XP) or Documents (in earlier versions of Windows), and click the workbook's name. (Windows keeps track of the 15 most recently opened documents created in any program.)
To open a workbook file that is stored on a drive or in a folder other than My Documents, you need to know how to navigate to other drives and folders by using the Open dialog box. First, click the arrow to the right of the Look in box, as shown in Figure 3.9. This displays a list of disk drives and other storage areas on your computer and, if your computer is networked, on the network. Click the desired storage location. The contents of this location is displayed in the Folder/File list, as shown in Figure 3.10. Double-click a folder to view its contents. Continue double-clicking folders until you reach the folder that contains the desired workbook, and then double-click the workbook's name.
If you pass up a folder while navigating, click the Back or Up One Level button in the Open dialog box's toolbar to back up to the previous folder or file list.
Figure 3.9 If a workbook is not in My Documents, you may need to change to the folder in which it is stored.
Figure 3.10 Navigate to the folder in which your Excel workbook files are stored.