How to Open Excel in Different Windows

Because Microsoft Excel 2013 no longer allows saving workspaces with multiple views, you must use a workaround to open the same Excel document in more than one window or to display two different documents side-by-side. Double-clicking the document twice doesn't open two instances of Excel unless you modify the Windows Registry, and modifying the registry is a dangerous operation that can lead to various problems. If you prefer to avoid editing the registry, open a second window from within Excel or open a new Excel instance using a keyboard shortcut.

Open a Second Excel Window

Step

Open your first Excel document in Excel and then open a second Excel instance by holding "Alt," right-clicking the "Excel" icon in the taskbar and then selecting "Excel (desktop)" from the context menu.

Step

Release the "Alt" button when asked if you want to open a new instance of Excel and click "Yes" to open it. Open the second document in the second Excel window. Note that you can open the same document in both Excel windows.

Step

Open a second Excel window within the same instance by launching Excel, opening the document, clicking "View" and then clicking "New Window" in the Window group. The same document is opened in both windows. Note the two windows are part of the same Excel instance; edits made in any of the windows are immediately reflected in the other window. Click "View Side by Side" to view different sections of the same document.

Open the Same Document by Double-clicking It

Step

Press "Windows-X" to display the Power User menu, click "Run," type "regedit.exe" into the "Open" field and press "Enter" to open the Windows Registry Editor. Be careful -- changing or deleting the wrong keys or values may cause programs to malfunction and even crash the entire operating system.

Step

Double-click the "HKEY_CLASSES_ROOT" key to expand it and then expand the "Excel.Sheet.12\shell\Open" key. Select the "command" key and locate the "(Default)" value in the right pane.

Step

Double-click the "(Default)" value to edit it and then replace "/dde" with "/e" and append "%1" (including the quotation marks) to the string in the "Value data" field. The value data must look like this: "C:\Program Files\Microsoft Office\Office15\EXCEL.EXE" /e "%1". Click "OK" to save the changes.

Step

Right-click the "command" value below the (Default) value and choose "Rename" from the context menu. Type a different name -- "command.old" for example -- and press "Enter" to rename the value.

Step

Right-click the "ddeexec" key in the left pane and choose "Rename" from the context menu. Type a different name -- "ddeexec.old" for example -- and press "Enter" to rename the key.

Step

Close the Registry Editor and then test the changes. Double-click the Excel document to open it in Excel. Return to the document and then double-click it again. When the File in Use dialog displays, click "Read Only." The document is opened as read-only in the second Excel window, so you can't edit it.