Open Excel 2010 worksheets in individual windows

Posted on 2011-10-12
Last Modified: 2012-06-27
I have a simple question. I am using Excel 2010 in Windows 7. When I double-click a workbook, it opens - no problem. When I double-click a second one, it also open. However, after the first one, Excel open all the others on top the previous one.

I know I can roll the mouse over the task bar, and see all open workbooks. I can also arrange the workbooks from inside Excel.

However, is there any way i can get each workbook to open in its own window simply by double-clicking on it?
Question by:patkengroup
    LVL 2

    Expert Comment

    There is a way, but it would involve messing with the Windows registry. Are you up to it?
    LVL 31

    Accepted Solution

    Why would you need the files in separate instances of Excel?

    Ctrl + Tab within Excel does the same as Alt + Tab in Windows, although I have read somewhere about that key combination changing in Windows 7. New combination Ctrl + Alt + Tab.

    Rob H

    Author Closing Comment

    I'm a LAN admin, and a couple of the users asked me if Excel could do that. They said it was possible with previous versions of Excel, but I had no personal experience with it. That is where the question came from.

    I gave them your answer, and that satisfied them, so we are all good. Thanks for the quick response.

    Featured Post

    Free Trending Threat Insights Every Day

    Enhance your security with threat intelligence from the web. Get trending threat insights on hackers, exploits, and suspicious IP addresses delivered to your inbox with our free Cyber Daily.

    Join & Write a Comment

    Introduction This Article briefly covers methods of calculating the NPV and IRR variants in Excel as well as the limitations in calculating and interpreting IRR results. Paraphrasing Richard Shockley, author of my favourite finance reference tex…
    This tutorial explains how to create a series of drop-down lists that are dependent upon prior selections to guide (“force”) the user to make the correct selection and reduce data errors within Microsoft Excel. Excel 2010 was used for this tutorial;…
    This Micro Tutorial will give you basic overview of the control panel section on Windows 7. It will depth in Network and Internet, Hardware and Sound, etc. This will be demonstrated using Windows 7 operating system.
    This Micro Tutorial will demonstrate the scrolling table in Microsoft Excel using the INDEX function.

    755 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    24 Experts available now in Live!

    Get 1:1 Help Now