Microsoft Excel is the tool part of the Office Suite in which you can perform a myriad of operations. If you are someone who uses Excel a lot, whether for personal or professional use, I imagine having the ability to access two Excel spreadsheets at the same time is something that could benefit you a lot. In this article we are going to see how to open 2 separate Excel files at the same time, in 2 separate windows.
The topics of the post [ hide ]
- 1How to open two Excel files in separate windows?
- 12 or Multiple Excel Files in separate windows using Shift key and taskbar
- 2Open two or more Excel files in separate windows Using the start key
- 3Open Excel files in separate windows with Office tab
- 2Conclusions
How to open two Excel files in separate windows?
If you need to work on 2 Excel files at the same time, I am sure you will love these 3 solutions that I am going to list in a few moments. Among the various options available to open multiple files on Excel in separate windows, we find the use of keyboard shortcuts, via the start menu, and much more.
2 or Multiple Excel files in separate windows using Shift key and taskbar
- First you need to have an Excel spreadsheet already open on your computer.
- Now, press the Shift key and click on the Excel file icon from the taskbar
- A new blank Excel worksheet will open.
- Click File> select the excel spreadsheet you want to start working at the same time.
Once you have done these operations, you will very well notice that you will have 2 files open simultaneously on your screen.
Open two or more Excel files in separate windows Using the start key
This method is much simpler, here’s what you need to do:
- Open the first Microsoft Excel spreadsheet you want to use.
- Now do the same to open the second Excel file.
- Now select one of the 2 calculation files and click the start button + a directional arrow of your choice (right / left)
Once you have done this you will see that the 2 Excel spreadsheets will completely fill your display, thus allowing you to work simultaneously on multiple Excel files.
Open Excel files in separate windows with Office tab
As a final method I decided to list one that requires a little more work, but still turns out to be quite effective. Specifically it requires the installation of an application / add-on called Office Tab. This utility presents you with an option called “Open in new window”.
- After installing Office Tab, open the workbooks you want to use in separate windows
- These workbooks will, by default, all open in a window and tabbed at the top
- Right click on the workbook you want to bring to a separate tab and click “Open in new window”
- This will do the job. Your workbooks will now appear in separate tabs.
Conclusions
Opening Two Excel Files in Separate Windows is a very useful operation to know. If you use Excel in a professional way, or in any case it is used to carry out jobs that require multiple Excel files at the same time, knowing how to work on 2 Excel files in separate windows becomes something fundamental.