Contact Us:

sales@sadasystems.com
+1 818 927-3660


Open Multiple Excel 2007 Windows

A work-around covered by tip site Online Tech Tips allows you to open more than one session of Microsoft Excel 2007.

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


All of the above are basic text files. To make use of this feature you will need to rename each file and change “.txt” to “.reg.” Then double click the file and click OK when prompted (Excel should be closed when you do this). That’s it! The option will now appear in the menu that opens when you right-click on an excel icon (pictured below).

For all the details read the article on OnlineTechTips.

 

Topics:

Leave a comment

Your email address will not be published. Required fields are marked *

You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <s> <strike> <strong>

×

×

×

×

×

×

×

×

×

×

×

×

×

×

×

×

×