Microsoft Office Tutorials and References
In Depth Information
Opening Your Workbooks for Editing
Operating the Open dialog box
After you select a folder and drive in the Excel 2013 Open screen or press the
Ctrl+F12 shortcut from within Excel, the program displays an Open dialog
box similar to the one shown in Figure 4-2. The Open dialog box is divided
into panes: the Navigation pane on the left, where you can select a new folder
to open, and the main pane on the right showing the icons for all the
subfolders in the current folder, as well as the documents that Excel can open.
The folder with contents displayed in the Open dialog box is either the one
designated as the Default File Location on the Save tab of the Excel Options
dialog box, the folder you last opened during your current Excel work
session, or the folder you selected in the Open screen of the Backstage view.
To open a workbook in another folder, click its link in the Favorite Links
section of the Navigation pane or click the Expand Folders button (the one with
the triangle pointing upward) and click its folder in this list.
If you open a new folder and it appears empty of all files (and you know that
it’s not an empty folder), this just means the folder doesn’t contain any of
the types of files that Excel can open directly (such as workbooks, template