How to open 2 Excel files at the same time on the screen

In the process of working with Excel, sometimes you need to process 2 or more Excel files at the same time, but the version of Excel you are using cannot open. So you are looking for ways to open 2 Excel files at the same time on the screen, so let's find out in TipsMake.com in the article below.

In the process of working with Excel, sometimes you need to process 2 or more Excel files at the same time, but the version of Excel you are using cannot open. So you are looking for ways to open 2 Excel files at the same time on the screen, so let's find out in TipsMake.com in the article below.

How to open 2 Excel files at the same time on the screen Picture 1How to open 2 Excel files at the same time on the screen Picture 1

Here's how to open 2 Excel files at the same time on the screen, and how to open 2 Excel files into 2 computer screens, please follow along.

Open 2 Excel files at the same time on the screen

For Microsoft Excel 2013 and 2016, you can open 2 or more Excel files directly by double clicking on the file you want to open.

How to open 2 Excel files at the same time on the screen Picture 2How to open 2 Excel files at the same time on the screen Picture 2

For lower versions of Excel to open 2 Excel files at the same time on the screen, you need to do the following:

Step 1: Open the first Excel file on your computer as usual.

How to open 2 Excel files at the same time on the screen Picture 3How to open 2 Excel files at the same time on the screen Picture 3

Step 2: Under the Excel icon in the Taskbar, hold down the Shift key and click the left mouse button to open a new Excel window.

How to open 2 Excel files at the same time on the screen Picture 4How to open 2 Excel files at the same time on the screen Picture 4

Then you select File -> Open and select the folder containing the 2nd Excel file that you want to open at the same time as the first Excel file.

How to open 2 Excel files at the same time on the screen Picture 5How to open 2 Excel files at the same time on the screen Picture 5

So you will open 2 Excel files at the same time on the screen as shown below.

How to open 2 Excel files at the same time on the screen Picture 6How to open 2 Excel files at the same time on the screen Picture 6

To open 2 Excel files in 2 parts of the computer screen, you can do the following:

Step 1: On the first Excel file window, click and hold the file and drag the mouse pointer to the left edge of the computer screen (or Windows + key combination

How to open 2 Excel files at the same time on the screen Picture 7How to open 2 Excel files at the same time on the screen Picture 7

Thus the Excel file will be scaled down and fit to the left half of the screen.

How to open 2 Excel files at the same time on the screen Picture 8How to open 2 Excel files at the same time on the screen Picture 8

Step 2: Next on the second Excel file, click and hold the file and drag the mouse to the right edge of the computer screen (or press Windows + -> (right arrow key)).

How to open 2 Excel files at the same time on the screen Picture 9How to open 2 Excel files at the same time on the screen Picture 9

Thus the second Excel file will be scaled down to the right half of the screen.

How to open 2 Excel files at the same time on the screen Picture 10How to open 2 Excel files at the same time on the screen Picture 10

Above the article has shown you how to open 2 Excel files at the same time on the screen. Hopefully through this article you will understand and can quickly open 2 Excel files no matter which version of Excel is used. Good luck!

3.7 ★ | 3 Vote