Page 202 - Excel 2013 All-in-One For Dummies
P. 202
184 Opening a Workbook Opening a Workbook
One of the simplest ways to open a workbook for editing in Excel is to open its folder in Windows Explorer and then double-click the workbook file icon. If you haven’t yet started Excel 2013 at the time you open the workbook, Windows automatically launches Excel at the same time that it opens the file.
Keep in mind that Excel automatically saves workbook files in your Documents folder unless you specifically select another folder or you save your workbooks online on your SharePoint site, SkyDrive, or Dropbox. You can search for the Excel document you want to open from the Windows 8 Start screen (where you simply start typing the name of the file) or with the Search Programs and Files text box on the Windows 7 Start menu.
If you can’t remember where you saved the workbook that you need to edit (a common occurrence), you can browse for the workbook file from the Open screen or use the Search Documents text box in the Open dialog box to locate the file. See the “Finding misplaced workbooks” section later in this chapter for details.
Using the Open screen in the Backstage view
If Excel 2013 is already running and you want to open a workbook file for edit- ing from within Excel, you can click File➪Open or press Alt+FO or Ctrl+O to launch the Open screen in the Backstage view and locate and open the file.
When Excel displays the Open screen (similar to the one shown in Figure 3-1), the program selects Recent Workbooks under Places on the left, while listing recently opened workbook files on the right. If the workbook file you want to edit is listed there, you can open the file simply by clicking its name in the list.
If the workbook file is not among those in the Recent Workbooks list, you need to select its location under Places:
✦ SkyDrive to find a workbook saved in a folder online on your SkyDrive
✦ Computer to find a workbook file saved in folder on a local drive, which includes your computer’s hard drive or a network drive to which you have access or even a removable storage device connected to your com- puter or tablet PC