How To Open New Excel Sheet In New Window

When you effort to open ii Microsoft Excel spreadsheets, they go into the same Excel window. This is annoying, to say the least, when you are trying to compare two separate Excel spreadsheets side by side. While it is true that you an overstate your master Excel program window and then resize the underlying open spreadsheet windows to fit, this is a less than ideal solution in my opinion.

In this commodity I will share with you a few means to open multiple instances of Microsoft Excel so yous can accept separate Excel spreadsheets open on dual monitors.

Alt + Excel

This option assumes you already have an Excel spreadsheet open and want to open a new Excel window to open a separate spreadsheet file in.

To open a new separate Excel program window, press and hold down the "Alt" primal on your keyboard when clicking on the Microsoft Excel program icon. A new and carve up Excel spreadsheet window will announced. This volition allow you to put your spreadsheets side by side or swap back and along using the Alt + Tab keys on your keyboard.

This option assumes you already have an Excel spreadsheet open down on your taskbar and want to open up a new Excel window to open up a separate spreadsheet file in.

To open a new separate Excel programme window, press and hold downward the "Alt" key on your keyboard so click on the Excel taskbar icon using your mouse gyre wheel. This will open a new Excel spreadsheet in a separate window. This volition let you to put your spreadsheets adjacent or swap back and forth using the Alt + Tab keys on your keyboard.

This option assumes you already accept an Excel spreadsheet open and want to open up a new Excel window to open a dissever spreadsheet file in.

Click on the Windows "Start" icon (the Windows logo) downwardly at the bottom left of your screen then type "excel.exe /10" without the quotes and press the "Enter" key on your keyboard. Only blazon it in, at that place is no location to type but it volition automatically perform the part for you when you brainstorm typing.

Quick Steps: Click Start > Blazon excel.exe /x > Printing Enter

Edit the Registry

If you lot plan on always opening your Microsoft Excel spreadsheets in new windows you lot can edit your Windows Registry to achieve this.

Note: This will only piece of work when y'all use the Excel icon to open a new spreadsheet. When opening a new spreadsheet from inside Excel (File > Open), the file will open in the electric current Excel window. The aforementioned applies when opening a file from within file explorer.

WARNING: Editing the Registry on your Windows based PC is unsafe and tin outcome in the loss of information. Always have a recent backup ready for deployment should the need arise.

Begin by endmost completely out of Microsoft Excel. Then click on the Windows "Start" icon (the Windows logo) down at the bottom left of your screen then type "Regedit" without the quotes and press the "Enter" central on your keyboard.

Inside the Registry address bar at the top, copy and paste the post-obit:

• Computer\HKEY_CURRENT_USER\SOFTWARE\Microsoft\Office\

Depending upon your version of Microsoft Office, select the version (example 14.0 or 16.0), then click on the "Excel" folder, then "Options" folder. For case, if you had Microsoft Role 2010 the total address would exist:

• Computer\HKEY_CURRENT_USER\SOFTWARE\Microsoft\Office\14.0\Excel\Options

You should at present exist on the Options binder, correct click on the Options folder and click "New" then "DWORD (32-fleck) Value". Name the new key: "DisableMergeInstance" and printing Enter.

Side by side, double-click on the newly created "DisableMergeInstance" entry and change the Value data 1 and click the OK button.

The next fourth dimension you lot open up a new Excel window using the taskbar icon, it will open up in a new instance of Microsoft Excel.

Conclusion

I welcome your thoughts, questions or suggestions on my article on how to open ii separate Microsoft Excel spreadsheet windows for side by side comparing of your excel spreadsheets.

Y'all may support my piece of work by sending me a tip using yourBrave browser or by sending me a in one case donation using your credit menu.

Let me know if you lot found any errors inside my article or if I may further assistance yous by answering any boosted questions yous may have.

Source: https://endurtech.com/how-to-open-two-separate-excel-spreadsheet-windows/

Posted by: ellismandred48.blogspot.com

Share this post