How to Open Two Excel Files Separately in Different Windows (5 Methods)

Method 1 – Use Shift Key and Taskbar

  • Open the first Excel file (e.g., Data-1).

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

  • Press the Shift key and click the Excel icon on the taskbar.

  • A new workbook (Book1) will open in a new window.

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

  • From the newly opened workbook (Book 1), go to File > Open > Browse and choose the second file (Data-2).

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

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

  • Click on Open.

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

  • Both Excel files (Data-1 and Data-2) will now be open in separate windows.

Read More: How to Open Excel Files in Separate Windows by Default


Method 2 – Right-Click

  • Open an Excel file in advance (e.g., Data-1).
  • Right-click the Excel icon on the taskbar and select Excel.

  • A new Excel workbook will be created.
  • From the new workbook, go to File > Open > Browse and open the second Excel file.

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

  • Both files will be opened separately.


Method 3 – Start Menu Approach

  • Open an Excel file.
  • Click the Start menu and type excel in the search box.
  • Click the Excel app to create a new workbook in a separate window.

Open Two Separate Excel Files with the Help of Start Menu

  • The new Excel workbook will be created in a separate window.

Open Two Separate Excel Files with the Help of Start Menu

  • From the newly opened workbook, go to File > Open > Browse and open another file separately.


Method 4 – Create a Shortcut

  • Locate the EXCEL.EXE file (different paths for different Excel versions). 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 path below to get the EXCEL.EXE file.

For Windows 10: C:\Program Files\Microsoft Office\root\Office12/14

  • Right-click on it and select Create Shortcut.

Create Shortcut for Displaying Two Excel Files Separately

  • The shortcut will appear on your desktop.

Create Shortcut for Displaying Two Excel Files Separately

  • Double-click the shortcut to open workbooks in separate windows.

Method 5 – Open Two Separate Excel Files Using ‘Send to’ Menu

  • Create an Excel Shortcut (Method 4):
    • Create an Excel shortcut using Method 4 (as described earlier).
    • Copy the shortcut.
  • Navigate to the SendTo Folder:
    • Go to the following path:

C:/Users/UserName/AppData/Roaming/Microsoft/Windows/SendTo

    • Paste the Excel shortcut icon into the SendTo folder.

Open Two Separate Excel Files Using ‘Send to’ Menu

  • Open Excel Files Separately:
    • Right-click on any Excel file (e.g., Data-1) that you want to open in a different window.
    • Go to Send to > EXCEL – Shortcut.

    Open Two Separate Excel Files Using ‘Send to’ Menu

  • The Excel file will open in a separate window.
  • Repeat the process to open another Excel file (e.g., Data-2) separately.

Read More: How to Open Multiple Excel Files in One Workbook


Things to Remember

  • You can also view two Excel files side by side in separate windows using the View tab in Microsoft Excel.
  • Starting from Excel 2013, you can open Excel files separately in different windows by default.

Download Practice Workbook

You can download the practice workbook from here:


Related Articles


<< Go Back to Open Excel Files | Excel FilesLearn Excel

Get FREE Advanced Excel Exercises with Solutions!
Hosne Ara
Hosne Ara

Hosne Ara is a materials and metallurgical engineer who loves exploring Excel and VBA programming. To her, programming is like a time-saving superhero for dealing with data, files, and the internet. She's skilled in Rhino3D, Maxsurf C++, MS Office, AutoCAD, and Excel & VBA, going beyond the basics. With a B. Sc. in Materials and Metallurgical Engineering from Bangladesh University of Engineering and Technology, she's shifted gears and now works as a content developer. In this role, she... Read Full Bio

4 Comments
  1. Great and very useful.. searching for this for long time
    Thanks a million

  2. My system operates on windows 10 and has excel 2007. I am unable to separate 2 excel files using above method. Please advise if available – thanks

    • Reply Avatar photo
      Md. Abdur Rahim Rasel Jan 4, 2024 at 5:12 PM

      Hello SAJJAD!
      Thanks for reaching out and sharing your problem with us.
      I think the article is appropriate for fixing your problem. You can try again following the steps in the article, and if you cannot fix the problem, feel free to ask for assistance.
      Again, thank you for being with us.
      Regards
      Md. Abdur Rahim Rasel
      Exceldemy Team

Leave a reply

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo