In this article, I will discuss how you can open two excel files separately in different windows. People who are using updated versions of excel won’t face difficulties while opening excel files in separate windows. However, earlier versions of excel (e. g. Excel 2010/Excel 2007) use a Multiple Document Interface where all different workbook windows are opened under a master window. Thus all the opened windows share a common ribbon which seems inconvenient sometimes. So, if you want to open workbooks in separate windows let’s go through the article.
Download Practice Workbook
You can download the practice workbook that we have used to prepare this article.
5 Methods to Open Two Excel Files Separately
1. Use Shift Key and Taskbar to Open Two Files Separately in Excel
You can open two different excel files separately from the taskbar using the Shift key. Suppose, we have two excel files named Data-1 and Data-2. Follow the below steps to open these two files in different windows.
Steps:
- Initially, you have to open the first file. Say, I have opened the file Data-1.
- Next, press the Shift key from the keyboard and click the Excel icon from the taskbar.
- As a result, you will see that a new workbook (Book1) is opened in a new window.
- Now, we will open another excel file (Data-1) from the newly opened workbook. To do that, from the Excel Ribbon, go to the File tab from Book1.
- Then, go to Open > Browse to choose the second file.
- Upon clicking on the Browse option the Open window will appear, go to the file location and select the second file (here Data-2), and press Open.
- Finally, we can see both excel files (Data-1 and Data-2) are now open in separate windows.
Read More: How to View Excel Sheets in Separate Windows (4 Methods)
2. Get Two Excel Files One by One by Using Right-Click
In this method, I will open two different files by simply right-clicking on the excel icon from the taskbar.
Steps:
- Similar to the previous method, open an excel file in advance (say Data-1).
- Then right-click on the excel icon located in the taskbar and press Excel.
- Consequently, a new excel workbook will be created. Now, from the new workbook, go to File > Open > Browse to open the second excel file.
- Finally, likewise in Method 1, we can see two excel files have been opened separately.
Similar Readings
- How to Separate Sheets in Excel (6 Effective Ways)
- [Fix:] Excel View Side by Side Not Working
- How to Split Excel Sheet into Multiple Files (3 Quick Methods)
- Enable Side-by-Side View with Vertical Alignments in Excel
- How to Split Sheets into Separate Workbooks in Excel (4 Methods)
3. Open Two Separate Excel Files with the Help of Start Menu
Now, I will show how we can open two excel files in separate windows using the Start menu from your PC. Follow the below steps to do the task.
Steps:
- Like previous methods, open an excel file in advance.
- Then click on the Start menu, and type ‘excel’ in the search box. When the Excel app appears upon search, click on it.
- As a consequence, a new excel workbook will be created in a separate window.
- Finally, from the newly opened workbook window, go to File > Open > Browse to open another file separately.
4. Create Shortcut for Displaying Two Excel Files Separately
In this method, I will open two excel files separately by creating an excel shortcut icon. You can open two excel files in separate windows by clicking on the excel shortcut icon. Let’s follow the below steps to get desired output.
Steps:
- To get the excel shortcut, first, you have to locate the EXCEL.EXE file. You have to follow different paths for different versions of excel to get the above-mentioned file. Such as:
For Excel 2010: C:\Program Files\Microsoft Office\Office 14
For Excel 2007: C:\Program Files\Microsoft Office\Office12
If you are using Windows 10, follow the below path to get the EXCEL.EXE file.
For Windows 10: C:\Program Files\Microsoft Office\root\Office12/14
- Next, when you locate the EXCEL.EXE file, right-click on it and select Create Shortcut.
- Then, the Shortcut window will appear, press Yes.
- As a result, the below shortcut will be created on the desktop.
- Once the excel shortcut is created, double-click on it to get workbooks in different windows and thus open two files separately.
5. Open Two Separate Excel Files Using ‘Send to’ Menu
You can open two files in excel by right-clicking and selecting Send to menu. If you have to open new excel files often, then you can use this technique.
Steps:
- First, create the excel shortcut using Method 4 and copy it.
- Next, go to the below path:
C:/Users/UserName/AppData/Roaming/Microsoft/Windows/SendTo
- Then paste the shortcut icon in the SendTo folder.
- Now, right-click on any excel file (here, Data-) that you want to open in a different window, and go to Send to > EXCEL – Shortcut.
- As a consequence, the excel file will open in a separate window. Now you can open another excel file (say Data-2) by repeating the process.
Read More: How to Open Multiple Excel Files in One Workbook (4 Easy Ways)
Things to Remember
- You can view two excel files side by side in separate windows by using the View tab in Microsoft Excel.
- The good news is, from Excel 2013, we can open excel files separately in different windows by default.
Conclusion
In the above article, I have tried to discuss several methods to open two excel files separately elaborately. Hopefully, these methods and explanations will be enough to solve your problems. Please let me know if you have any queries.
Related Articles
- How to Split a Workbook to Separate Excel Files with VBA Code
- Excel VBA: Split Sheet into Multiple Sheets Based on Rows
- How to Split Screen in Excel (3 Ways)
- Split Excel Sheet into Multiple Sheets Based on Column Value
- How to Split Excel Sheet into Multiple Worksheets (3 Methods)
- Split Excel Sheet into Multiple Sheets Based on Rows