How do I open an Excel file in a separate window?

In the article how to avoid the Excel 2010 window size synchronization, we indicate how to open, arrange multiple Excel files in a window. But many students who use Windows 7 still prefer the two windows. A pull by the left and right, both easy to compare, and not interfere with the operation. The problem is that when you open more than one Excel file, it always appears in a window, how do you open the file in a separate window?

A more secure approach is to open the Excel program directly from the Start menu, and then use file-open in a new Excel program to open the file. is equal to opening a new Excel.exe process.

(Small easy to have the hand: directly in the taskbar mouse button click the Excel program icon to open a new program)

Excel20102007 opened the file in a window originally intended to save memory. However, if you have a lot of machine memory and want to change it once and for all, try the following method.

Method One: Fixit automatic modification

Click the "resolve this issue" link, click Run in the File Download dialog box, and then follow the wizard.

(Small hint: Because the modification involves registry modification, in order to avoid accidental or easy to restore later, the Fixit tool will create a registry backup on the desktop)

Resolve this issue

Microsoft Fix It 50801

Method Two: Manual modification

Use the shortcut key combination "Win+r" to pull up the Run command box, type Regedit.exe, enter, and open Registry Editor.

(If pop-up User Account Control window, please allow to continue)

Small tip: If the registry is incorrectly modified, there may be serious problems. Therefore, make sure that you follow these steps carefully. To increase protection, please back up the registry before modifying it.

Navigate to the registry key value: Hkey_classes_rootexcel.sheet.12shellopen

Right-click and select Export. We'll make a backup of it before we change it.

After a good backup, you can make bold changes.

Modify the Opencommand value.

Expand "Opencommand", in the right detail window:

Double-click to open Default and change its key value to "C:Program filesmicrosoft OfficeOffice14EXCEL.EXE" "%1"

(If you are using Office 2007, change Office 14 to office 12.) In addition, do not lose the quotation marks)