Microsoft Office Tutorials and References
In Depth Information
Each heading has its own menu of options, some of which are based on the actual files
contained in the current folder. For example, when you click the menu arrow for the Type
heading, you can select from a list of file types contained in the folder.
Special ways to open files
To the right of Open at the bottom of the Open dialog box is a small arrow. Clicking this
arrow displays a menu containing the following options:
Open Read-Only This opens the file so that you cannot save any changes made to
it without renaming it.
Open As Copy This creates a duplicate of the selected file, adds the words Copy of
to the file name, and leaves the original untouched.
Open In Browser This applies only to HTML documents and opens the selected file
in your default web browser.
Open In Protected View This opens the document for viewing but not editing.
All active content is disabled, including any kind of macro or HTML code. Once you
have established the bona ides of the file, you can click the Enable Editing button to
Open And Repair This is a powerful feature you can use to try opening corrupted
files. For more information, see “Recovering corrupted files” later in this chapter.
Opening files when you start Excel
If you have files you need to work on every day, you can store them in a special folder
called XLStart. Every time you start Excel, any files in the XLStart folder automatically open.
The XLStart folder is created when you install Excel (or you can create it yourself) and is
located in the following place:
Windows 8, 7, or Vista C:\Users\< your name >\AppData\Roaming\Microsoft\
Windows XP C:\Documents and Settings\< your name >\Application Data\
If you want to start Excel and simultaneously open files that are in a folder other than the
XLStart folder, you can specify an alternate startup folder. Click the File tab, click Options,
and select the Advanced category. Scroll down to the General category, and in the edit box
labeled At Startup, Open All Files In, type the full path of the folder. This feature is
particularly useful if your computer is connected to a network and you want to open files from a