Microsoft Excel is a spreadsheet that organizes numbers and data with formulas and functions. Excel analysis is used all over the world for financial analysis of all types of business. If you use excel for personal or professional uses you might feel the need to use two spreadsheets at the same time. In this article, I am going to show you some easy processes to open excel files in separate windows by default. So that, you don’t have to open files in a similar window.
Download Practice Workbooks
Download these practice workbooks to exercise while you are reading this article.
4 Suitable Methods to Open Excel Files in Separate Windows by Default
Today I am explaining 4 suitable methods to open excel files in separate windows by default. Stay tuned to learn the simple methods.
Suppose we have two excel spreadsheets containing data on sales of two Shops. One is the Sales of Fruits and the other is the Sales of Groceries.
Let’s open these datasets on our PC. As you can see when we open both files they open in the same window. Now we will apply some techniques so that they open in different windows.
1. Utilize Office Tab to Open Excel files in Separate Windows
If you want to open two excel spreadsheets in two separate windows without any hesitation then you are in the perfect place for your solution. Utilizing the office tab we can get our precious result. Hope you have the “Office Tab” installed on your PC. If not, don’t forget to check the “Things to Remember” portion at the end of this article. Stay tuned and follow the steps-
- Firstly, open a spreadsheet. Here I have opened the file “Sales of Fruits”.
- Go to “File” to open options.
- Choose “Table for Excel Options” from the “Office Tab”.
- From the new window uncheck the “Single-window Mode”.
- Press OK to continue.
- Hereby unchecking the option we have successfully reached our destination. Now open both excel files and you will see both of them will open in a separate window.
Read More: [Solved] Excel Files Not Opening in Separate Windows (4 Solutions)
2. Use Registry Editor to Open Excel files in Separate Windows
In the previous method, we used a built-in feature of Excel to do so. Now let’s use “Registry Editor” to open excel files in two separate windows. Follow the steps carefully and patiently to get your precious result.
- Click on the “Search” option from your taskbar.
- Type “Registry Editor” to search from your computer.
- Now choose “Registry Editor” from your search result and click on it to open.
- From the left column press onto “Excel.CSV”.
- Again click on the “Open” option and select “ddeexec”.
- Right-click on the “ddeexc” file and rename the file.
- Now go to the “Command” option and choose “Default” from the right column.
- While selecting the “Default” right-click the mouse button and press “Modify”.
- A new window will open named “Edit String”.
- Here you have to edit the string. At the end of the string type- /e”%1”
- Press OK to change the string.
Now we will do the same steps in a new file from the left column.
- Go to Sheet.12 > Shell > Open > ddeexec.
- Selecting “ddeexec” click on the right button of the mouse and from the options choose the “Rename”.
- Here I have renamed the file to “7”.
- Now we will head towards the “Command” point.
- After selecting the “Command” point from the left column a new option will appear in the right side column.
- Press the “Default” option and click the right button on the mouse to open options.
- From the options, select modify to edit the string.
- At the end of the string type- /e”%1”
- Click OK.
- Now close the “Registry Editor” file.
- Let’s open the excel files. You will see the excel files will open in two separate windows.
3. Create a Custom Excel Shortcut to Open Excel files in Separate Windows
By creating a shortcut in your window you can open an excel file in Separate windows too. Follow my steps-
- Click the right button on the mouse selecting the “Excel” shortcut from your window.
- Options will pop up. From the options choose “Properties”.
- A new window will appear named “Excel Properties”.
- Click the “Shortcut” and copy the location from the “Target” option.
- Now go to your window and again click the right button on the mouse to get some new options.
- Select “Shortcut” from option “New”.
- In the “Create Shortcut” window paste by pressing Ctrl+V from your keyboard in the “Type the location of the item” cell.
- At the end of the string type- “ /x”.
- To continue click “Next”.
- Now name your excel file. Here I have named the file “Excel (2)”.
- Complete the process by pressing “Finish”.
- Now you will get a new excel shortcut icon in the window. With the previous icon, you can open a file and with the new icon, you can also open a new file in a separate window every time you click on it. It’s that easy.
Read More: Unable to Open Two Excel Files at the Same Time (13 Probable Solutions)
4. Search in Windows to Open Excel files in Separate Windows
Let’s move to our last step. In this method, I will show you some simple and quick steps so that you can open excel files in a separate window at a glance.
- Firstly, open an excel file.
- While it’s opened go to your “Search” option from the taskbar and type “Excel”.
- Choose the “Excel” app from the search result.
- From the “Home” option click on the icon from the right column to view files.
- Now select another file and press onto it to open.
- This time this will open in a new and separate window. Thus you will get your two different files opened in two different windows every time using this method.
Read More: [Fixed!] Unable to Open Multiple Excel Files (8 Reasons with Solutions)
Things to Remember
- If you don’t have the “Office Tab” installed on your PC. Go to browser and search “Office Tab”. Then download the file and install it. After complete installation of the file, open your excel file to enjoy the “Office Tab”.
In this article, I have tried to cover the simple and quickest ways to open excel files in separate windows by default. Take a tour of the practice workbook and download the file to practice by yourself. Hope you find it useful. Please inform us in the comment section about your experience. We, the ExcelDemy team, are always responsive to your queries. Stay tuned and keep learning.