Open Excel 2010 worksheets in individual windows

Posted on 2011-10-12
Medium Priority
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

Expert Comment

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

Accepted Solution

Rob Henson earned 2000 total points
ID: 36956660
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

ID: 36956752
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

Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

This article describes how to use a set of graphical playing cards to create a Draw Poker game in Excel or VB6.
Windows Explorer lets you open cabinet (cab) files like any other folder. In VBA you can easily handle normal files and folders, but opening and indeed creating cabinet files takes a lot more - and that's you'll find here.
This Micro Tutorial demonstrates using Microsoft Excel pivot tables, how to reverse engineer competitors' marketing strategies through backlinks.
Although Jacob Bernoulli (1654-1705) has been credited as the creator of "Binomial Distribution Table", Gottfried Leibniz (1646-1716) did his dissertation on the subject in 1666; Leibniz you may recall is the co-inventor of "Calculus" and beat Isaac…

840 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