How to open two Excel files in separate windows?
Each of the four ways is really simple once you find out about them, but they may not be apparent at a first glance.
1] Open Excel files in separate windows using the Shift key and the Taskbar
Have your first Excel workbook already open on your computerNow, press the Shift key and click on the Excel file icon from the taskbarThis will open a new, blank Excel workbook. You can use this blank workbook as a prompt to open any other workbook you’ve previously worked on and want to access simultaneously with the file opened initiallyClick on File > select the workbook of your choice
As you can see, we now have two Excel files running simultaneously in two separate windows
2] Open Excel files in separate windows with the Start menu
This method is just as easy as the first one. Do as follows:
Search for Excel from the search option of your Taskbar and open Microsoft ExcelClick on File and open the workbook you want to work onIf you want to open another file in a separate window, simply repeat the first two steps
This way, you can open as many files in separate windows as you want.
3] Open Excel files in separate windows by creating a shortcut
Thirdly, you can take the help of a manually created shortcut. You can make one by following the steps below:
Open File Explorer and visit the Office folder by visiting the following location. You can straight away copy and paste the address below, based on your Office versionOnce you’re there, locate the Excel application, right-click on it and select ‘Create a shortcut’Confirm this action and you’ll find an Excel shortcut on your desktop. Every time you click on it, a new Excel window opens
4] Open Excel files in separate windows with the Office Tab
The fourth method requires you to install an application/add-in called the Office Tab. This utility presents you with an option called ‘Open in a new window,’ making it the easiest and quickest way to do so. If you’re someone who finds himself working on multiple spreadsheets regularly, this tool can come in very handy for you.
Once you’ve installed Office Tab, open the workbooks you want to use in separate windowsThese workbooks will, by default, all be opened in one window and tabbed at the topRight-click on the workbook you want to take to a separate tab and click on ‘Open In New Window’This will do the job. Your workbooks will now appear in separate tabs.
Why can I not open multiple Excel files?
You can open multiple Excel files by making some changes in the way you start Excel. Don’t double-click on the workbook to open it, instead right-click on one of the files you want to open. Similarly, you can open multiple excel files while keeping the selection set intact.
Can I open multiple Excel files at once?
Yes, you can. Instead of double-clicking to open a file, you can create a “selection set.” To open multiple files, click on the first file, hold the Shift key and click on the last file in the sequence.
