How to Open Excel Files in a new Window?
Maybe you want to use two or more Excel spreadsheets at the same time (opened each file in separate windows), or open them on two monitors. Unfortunately by default Microsoft Excel 2010 (and Excel 2007) opens spreadsheets in the same window as they are designed as MDI applications. However you can do this by following this article.
This is a registry tweak and it works on Windows XP, Vista and Win7 with Microsoft Office 2003, 2007 and 2010. However, you need administrator access to your computer otherwise you won’t be able to modify the registry and you should be very careful when you have the registry editor open because accidental changes could crash your computer.
- Open registering editing tool. (Regedit)
- Navigate to “HKEY_CLASSES_ROOTExcel.Sheet.12shellOpen” (click to enlarge image)
- Right click on “Open” note and and export to file to save as backup.
- Go to “Command” node.
- Update the “Default” key to below value
"C:Program Files (x86)Microsoft OfficeOffice14EXCEL.EXE" /e "%1"
- Rename the “Command” key below the “Default” key to “CommandOld”
- Rename the “ddeexec” Node to “ddeexecOld”. You should see your registry changes similar to below pictures after change has been made:
- Now give it shot by open the “.xlsx” files, you will see each file is opened in new window. Beware each Excel.xxxx registry key is for each type of file that Excel as association with.For other type of extension based files fine below nodes and based on that I guess you can figure out your other type of files that you want to open to be configured the same.
File Type to Open Registry sub key File Version For .xlsx Excel.sheet.12 Excel 2010 file For .xls Excel.sheet.8 Excel 2003-2007 file For .csv Excel.CSV Comma separated file
Bear in mind that opening each file in new window means we are running new instance of Excel.exe program, which means more RAM memory are being used. You might want to avoid doing this if you computer is short in RAM otherwise you will have a very slow computer.
Not sure why this isn’t an option in Microsoft Office, because it’s asked so often and it is counter user friendly to ask ordinary users to hack the registry to enable this. But until they do, this registry tweak allows you to easily open Excel spreadsheets in new windows. Happy Excelling :-D