Thursday, May 17, 2012


How to open excel files in multiple windows


One of my biggest pet peeves in Microsoft Office is that Microsoft Excel doesn't allow you to open spreadsheets in multiple windows, so you have to revert to switching back and forth between windows if you are trying to compare two documents.  What a PITA!!  Thankfully, I found this fix on the 'net--just a few minor registry tweaks:

Start - Run - regedit:


Navigate to:
HKEY_CLASSES_ROOT/Excel.Sheet.8/shell/Open/command:
Changes:
Double Click on (Default) and add "%1" to the end of the string - "C:\Program Files\Microsoft Office\Office12\EXCEL.EXE" /e "%1"
Right Click on "command" – choose "rename" and add something to the name  - for example 2 (command2).

Navigate to:
HKEY_CLASSES_ROOT/Excel.Sheet.8/shell/Open/ddeexec:
Changes:
Right Click on the folder ddeexec and choose "rename" and add something to the name  - for example 2 (ddeexec2)

Navigate to:
HKEY_CLASSES_ROOT/Excel.Sheet.12/shell/Open/command:
Changes:
Double Click on (Default) and add "%1" to the end of the string - "C:\Program Files\Microsoft Office\Office12\EXCEL.EXE" /e "%1"
Right Click on "command"– choose "rename" and add something to the name  - for example 2 (command2).

 No restart required for the changes to take effect.  Enjoy!!