Now scroll down until you see the file type of 'XLS' under the column labled 'Extensions' Click on 'XLS' to select it. In Folder Options, select the 'File Types' tab.
#Always open excel file in new window windows
Windows Explorer opens, now select 'Tools' then on the dropdown menu select 'Folder Options'. Never edit the registry without creating a backup. Open window explorer by right clicking the Start button and select Explore. When opening a new spreadsheet from within a file from File Explorer or by using File -> Open in Excel, the file still opens in the current Excel instance. Having said that, this method only works when you use the Excel icon to open a new spreadsheet. However, whilst this approach is inherently the most dangerous / complex, it’s the only one where you can make Excel open a new instance each time.
#Always open excel file in new window how to
It’s a great way to make friends with your local IT department and learn how to re-format your hard drive. I show this for completion, but be very careful working with the registry. You can force Excel to open a new instance by default. As the menu appears, hold down the ALT key and left-click on the ‘Excel’ menu option.ĭo note, this method does not show a pop-up dialog to indicate you have initiated a new instance. Right click on the Excel icon in the taskbar.
I offer you no less than four alternatives. So, if you find yourself stuck with Excel running a resource-intensive task, here’s how you can open a second independent Excel application in an instance (get it?). You could still open a separate instance: you just had to do it differently. However, Excel 2013 onwards never ignored its origins. You could link to sheets on other screens (something you cannot do with multiple instances. Microsoft made our lives easier by allowing you to put Excel on two or more screens from the same instance. With the advent of Excel 2013, we forgot this trick. To circumvent this, you opened Excel again et voila! you could have Excel omnipresent across your display surfaces.
If you worked with Excel, all of your files had to be displayed on one screen (unless you were very inventive) – because they were all running from the same initiation of the program – an instance. However, Excel didn’t necessarily keep up with the price reductions. Working with multiple screens has been with us for many years as they have become cheaper to purchase and make it easier for us to do our work. Check the box in the new window that says 'Confirm open after download'. Select the 'File Types' tab and find the icon that says Microsoft Excel Worksheet in the Registered File types. In fact, you may not be familiar with the term, but you are probably aware of a workaround already. Open 'My Computer' and select 'Folder Options' under the 'View' menu. That’s because you are using what is known as the same instance of Excel.