Open two Excel files in two different windows

How to open two Excel files in two different windows, at the same time and with two Excel programns opened? The task seems easy, yet by default, Windows 10 opens both files in the same software, i.e. Excel 2016. So you have to navigate between the files, but can’t see them at the same time. It is therefore useful to have two windows, or even better, two screens to compare two Excel files.

How to open two Excel files in two different windows with Office and Windows?

To open 2 Excel files in different windows, just follow these 2 steps.

Start by opening the first file with Excel 2016

To open the first file, launch Excel 2016 and search for the file to open via File > Open > Browse.

Or double-click directly on the file from the Windows Explorer from inside the folder. For example from your Desktop if you have saved the file there. A window opens with your first file, it is an instance of Excel, or a program.

Open first Excel file
Open first Excel file

Finally to open two Excels files in two different windows: open the second file in a second instance of Excel

To open a second file, a second instance is needed, i.e. a second Excel program. To do this, simply open Excel again, as explained below:

  • Click on the Windows button on your PC and then on the letter E, launch the Excel program.
  • Or, quicker, if you have pinned it before, from the Windows taskbar, right-click and select Excel.
  • Once the second program is open, create or select the second existing file from your explorer, in the same way as the first.

Open second Excel instance and file to have two Excel windows.
Open second Excel instance and file to have two Excel windows.

It is important to click on the second Excel window before opening the second file, otherwise it will be opened in the first Excel program. This way you can see the two Excel files side by side and compare them easily.

The official Microsoft page on the Excel spreadsheet which is part of the Office 365 package. Renamed recently to Microsoft 365. The Microsoft offer exists for home as well as for Business.

Tip: With Windows 10 and Windows 11, you can use the Windows + Arrow keys (right or left) to position the windows. Thus, the windows are automatically split on the screen to obtain an Excel file on the left and one on the right.

To go further, if you analyse a lot of data regularly, then reading about pivoting the rows of an excel table into columns may be of interest to you.

Another interesting tip is how to split Excel date and time using two Excel mathematical formulas.

Be the first to comment

Leave a Reply

Your email address will not be published.