
Turn Windows Features on or off in Windows 10
Windows 10 is a modern operating system developed by Microsoft Corporation. It is the successor…
In Microsoft Excel when you open numerous they do not open in separate windows. Instead, users can navigate between them by clicking their thumbnail previews on the taskbar in Windows 10.
Some users, however, may need to open two MS Excel files in different windows to examine their contents side by side.
The methods below will show you how to open two or more Excel files in different windows. Let us discuss it.
Recommended Post:- Fixed: Excel not Opening on Windows 10 and 11
When you open several files with Excel 2013 or later, each workbook appears in its window.
By default, they all open in the same Excel instance. In most circumstances, this is sufficient.
However, if you run a long VBA script or recalculate complex calculations in one workbook, other workbooks in the same instance may become inactive.
Opening each document in a new instance fixes the problem because, while Excel is doing a resource-intensive action in one instance, you can work in a different workbook in another.
Here are some examples of when it makes sense to open each workbook in a new instance:
There are some steps to open two excel files side by side for users to open Excel spreadsheets in separate windows:
You can open the Excel application several times to have several Excel windows on your desktop.
Alternatively, if you wish you can open multiple Excel windows by pressing and holding the Shift key.
This will open another window for the application, which users can drag to both desktop sides as described above.
The Office Tab extension for Excel allows users to open spreadsheets in different windows. This is a $29 Excel add-on that adds spreadsheet tabs to Excel, and users can try it out for free for one month.
Excel will feature alternate tabs for individual spreadsheets after you install the add-on. Then, users can right-click a spreadsheet tab and select the Open in New Window context menu option from the context menu.
It is more convenient to open a specific workbook using File Explorer (aka Windows Explorer). The Alt key, as with the prior way, performs the trick:
If you need to launch fresh instances frequently, a custom Excel shortcut will make your life easier. To build a shortcut for starting a new instance, follow these steps:
It now only needs one mouse click to launch a new instance of Excel.
The quickest approach to launch a fresh instance of Excel is as follows:
This can also be accomplished by using the mouse wheel: while holding down the Alt key, click the Excel icon in the taskbar, followed by a click on the scroll wheel. Hold Alt until the pop-up window appears, as shown above.
To see how many Excel instances are running, launch Task Manager (the quickest approach is to press Ctrl + Shift + Esc together). Expand each instance to discover which files are nested there for more information.
Users with full versions of Excel 2019-2007 can compare two spreadsheets by selecting the View Side by Side option. The option is incorporated inside the app and is simple to enable.
There are several ways for users to open Excel spreadsheets in separate windows. Users can then drag windows to the left and right edges of the Windows desktop to view the contents of both spreadsheets.
However, Windows XP and Vista do not offer the Windows Snap feature, which allows you to arrange windows on the left and right edges of the desktop.