A lot of us now need to use Microsoft Excel to one extent or another. If you use it to plan your family’s budget, or to keep track of your comic book collection you may not have run into one of Excel’s major shortcomings. Excel 2007 does not allow you to open a new session in a separate window, so that you can see two spreadsheets side-by-side. This becomes a major problem if you want to run a task such as calculating everything on one spreadsheet. If there are other spreadsheets open, Excel will recalculate those as well, whether or not their data is related.
To be fair, Excel does allow you to change how windows are arranged. You can use this to open two spreadsheets in the same Excel session by changing the “Arrange All” option to “vertical.” This makes your open spreadsheet documents appear side-by-side in a single Excel window. While this sounds like Excel supports viewing two spreadsheets at once, it’s really only helpful if you have two monitors or a good-sized wide screen monitor. It’s not as helpful if you have a single, smaller (19″ or less, viewable area) monitor with a 4:3 aspect ratio. It also doesn’t eliminate problems like the calculation issue mentioned above. Also, if you open a third spreadsheet document Excel will arrange it alongside the other two.
This article posted on www.onlinetechtips.com solves the problem by making use of a registry hack. The term ‘registry‘ refers to a database in Windows that stores options and settings. Don’t let the term ‘hack’ scare you away. This is not a malware exploit of a Windows vulnerability. In this case ‘hack’ can be used interchangeably with ‘workaround.’ To make use of this option you will need to download this zip file. It includes five different files. Each file does something different. The features set by each file include:
- Add the ‘open in new Excel instance’ and make it the default
- Only adds the new instance option
- Only makes the new instance option the default
- Remove the open in new instance option
- Undo the default setting for the open in new instance option
For all the details read the article on OnlineTechTips.