Buzz
In the Excel realm, the need often arises to handle two or more Excel files simultaneously. However, your current Excel version might resist opening both at once. If you're on the quest for the secret to opening two Excel files side by side on your screen, join Mytour in unraveling the mysteries in the following article.
Discover how to open two Excel files simultaneously on your screen and split them into two sections of your computer display. Follow along for a step-by-step guide.
Unlock the Potential: Opening Two Excel Files Simultaneously on Your Screen
For Microsoft Excel 2013 and 2016, you can effortlessly open two or more Excel files by simply double-clicking on each file you wish to open.
For older Excel versions, here's how you can open two Excel files simultaneously on your screen:
Step 1: Open the first Excel file on your computer as usual.
Step 2: Under the Excel icon in the Taskbar, hold down the Shift key and left-click to open an additional Excel window.
Next, select File -> Open, and navigate to the folder containing the second Excel file you want to open alongside the first.
By doing so, you'll open two Excel files simultaneously on your screen as depicted below.
To have the two Excel files open in two sections of your computer screen, follow these steps:
Step 1: On the window of the first Excel file, click and hold the mouse on the file, then drag the mouse cursor to touch the left edge of the computer screen (or use the Windows key + <- (left arrow) shortcut).
This will shrink the Excel file, fitting it neatly into the left half of the screen.
Step 2: Next, on the second Excel file, click and hold the mouse on the file, then drag the mouse cursor to touch the right edge of the computer screen (or press the Windows key + -> (right arrow) shortcut).
This action will resize the second Excel file, matching the size of the right half of the screen.
This article has guided you on how to open two Excel files simultaneously on your screen. We hope you grasp the technique and can swiftly open two Excel files regardless of the Excel version. Best of luck!
