

The changes below have worked on Windows 7 and Windows 8. If you’re not familiar with or comfortable with making changes to the Windows Registry, read the Warning note above again. Goofing up changes in your Windows registry can cause serious problems – so proceed at your own risk. If you don’t know what the Windows registry is, consider getting some help with this.

SEARCH MULTIPLE EXCEL FILES WINDOWS 7 MANUAL
Changes to make in the Registry Warning: The steps below outline manual changes to be done on your Windows registry. The changes needed will require making some changes in the Windows Registry. This is handy for working with multiple worksheets – especially if you have more than one monitor. If you have Excel 2007 or Excel 2010, you can make a change on your system so that when you open an Excel file it will always open in a new Excel window. Setting up your system to open Excel files in separate windows I tried some of the changes and have documented what has worked for me on multiple systems with different versions of Windows as well as Excel. They were slightly different in their instructions and a little hard to follow. I found some others that outlined some Registry tweaks. I searched and found several posts that basically said “can’t be done” or “not supported”. In technical terms, Excel uses MDI instead of SDI. By default, it seems Excel 20 open separate files in the same instance of Excel. I was asked how set up Excel so that opening individual Excel files would open in separate Excel Windows. Facebook 0 Tweet 0 Pin 0 LinkedIn 0 Print 0
