By Sophia | Last Updated
"Why do Excel 2010 files not open in separate windows? It is very frustrating when I need to open multiple files and compare them side by side or put them on separate monitors. As I often work with many Excel files at one time, it is extremely slow and inefficient to open another instance of excel for each file then navigate back to the folder and open it. Is there any way to fix this huge problem?"
If you work with quite a few Excel files at the same time, you may want to know how to open Excel files in different windows in order to view them side by side so that you can better compare them. But the truth is that they are all opened in the same window. So it is very inconvenient and time-consuming to work with these Excel files in that case. This tutorial will teach you How to Open Two Excel 2010 Files in Different Windows.
Steps to complete:
How to open two Excel files in different windows? To sum up, you should open new blank Excel 2010 workbooks in different windows first of all, and then separately browse and view the Excel files that you want to open in these new workbooks. Now follow the below steps and instructions to learn how to do it.
There are several ways that you can adopt to open new instances of Excel in different windows. Choose one as per your preference from the below 3 options.
First of all, open an Excel workbook that you want to view in advance, hold the Shift key on the keyboard and then click the Excel icon on the taskbar. Then a new blank workbook in another window will be created.
You will find that these two workbooks are opened in two separate Excel windows.
Alternatively, you can right click the Excel icon and select Microsoft Excel 2010 or use the wheel on your mouse to click Excel icon to open a new instance. Repeat the steps to open more Excel workbooks in different windows.
Press the Windows icon on the keyboard, enter "Excel" into the search bar and the click the icon of Microsoft Excel 2010 to open an Excel workbook. Do the steps again to open multiple instances of Excel if you want.
1: Open the file location where your Office is installed. The default path for Excel 2010 is C:/Program Files/Microsoft Office/Office 14. If you installed Office in other location, just open it.
2: Find the Excel icon and right click it, select Create shortcut from the drop-down menu.
3: Click Yes to go ahead. Then you will see that the icon of the Excel shortcut is displayed on the desktop. You can double click it to create a new Excel window when you need.
Now that you have finished Step 1, it's time to open and view Excels files in these newly created workbooks from different windows. Well, how to open two Excel spreadsheets in different windows? Since you have finished Step 1, Step 2 is very easy. You just need:
In the newly created instances of Excel, click the button of File at the top left corner of the interface and select the option of Open to continue.
And then browse to the Excel files that you want to open, click the Open button to open it.
Repeat the steps to open multiple Excel files that you want to view in different windows. Here is an example in which two Excel spreadsheets are opened in two separate windows.
That's all the guidance on how to open excel spreadsheets in separate windows. If you complete the two steps, you can view Excel files in separate windows at the same time and side by side so that you can better work with them.
Related Articles:
