How to Open Two Excel Files Separately (5 Easy Methods)

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.

Use Shift Key and Taskbar to Open Two Files Separately in Excel

  • 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.

Use Shift Key and Taskbar to Open Two Files Separately in Excel

  • 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.

Use Shift Key and Taskbar to Open Two Files Separately in Excel

  • Then, go to Open > Browse to choose the second file.

Use Shift Key and Taskbar to Open Two Files Separately in Excel

  • 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.

Use Shift Key and Taskbar to Open Two Files Separately in Excel

  • Finally, we can see both excel files (Data-1 and Data-2) are now open in separate windows.


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.

Get Two Excel Files One by One by Using Right-Click

  • Finally, likewise in Method 1, we can see two excel files have been opened separately.


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.

Open Two Separate Excel Files with the Help of Start Menu

  • As a consequence, a new excel workbook will be created in a separate window.

Open Two Separate Excel Files with the Help of Start Menu

  • 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.

Create Shortcut for Displaying Two Excel Files Separately

  • Then, the Shortcut window will appear, press Yes.

Create Shortcut for Displaying Two Excel Files Separately

  • 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.

Open Two Separate Excel Files Using ‘Send to’ Menu

  • 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.

Open Two Separate Excel Files Using ‘Send to’ Menu

  • 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.

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.

Hosne Ara

Hosne Ara

Hi, This is Hosne Ara. Currently, I do write for ExcelDemy. I have a long experience working with different industries and I have seen how vast the scope of Microsoft Excel is. So, eventually, I started to write articles on Excel and VBA. Basically, my articles are targeted to help people who are working in Excel. By profession, I am an Engineer. Materials and Metallurgical Engineering is my major. Besides, I am a certified Project Manager (PMP) too. I have worked with Power Plant and IT industry earlier. As a person, I am detail-oriented and love doing research. Establishing a greener world is one of my mottos.

We will be happy to hear your thoughts

Leave a reply

ExcelDemy
Logo