I want to open 2 excel files in separate windows to view them side by side... but each time I try, it opens them in the same window

Anonymous
2009-11-14T01:05:58+00:00

I want to open 2 excel files in separate windows to view them side by side... but each time I try, it opens them in the same window.  is there a way around this?

Microsoft 365 and Office | Excel | For home | Windows

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments No comments
Answer accepted by question author
Anonymous
2011-03-15T22:03:50+00:00

I use Windows 7 and this is what works for me (just figured it out):

1.  Open your first Excel file and place it on the screen you want

2.  Open a new Excel file from the Excel icon

3.  The new file will open on top of the one you have already opened.  Drag it to the other screen

4.  Drag the icon for the second Excel file INTO the new (blank) Excel document

Voila!  Two separate screens.

Was this answer helpful?

800+ people found this answer helpful.
0 comments No comments
Answer accepted by question author
Anonymous
2010-04-30T19:36:49+00:00

ok, just because i don't have the petiance to wait for you to answer to my first question about which excel version you'r using i'll just give my solution for all the people who have w7 and office 2007:

the solution involves making little changes in the registry so i recommend making back up for just in case:

strart - run - regedit:

Left column

HKEY_CLASSES_ROOT/Excel.Sheet.8/shell/Open/commend:

Right column {adding (space)"%1"}

Double Click on (Default) and write - "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 (commend2).

Left column

HKEY_CLASSES_ROOT/Excel.Sheet.8/shell/Open/ddeexec:

Right Click on the folder ddeexec and choose "rename" and add something to the name 

  • for example 2 (ddeexec2)

Left column

HKEY_CLASSES_ROOT/Excel.Sheet.12/shell/Open/commend:

Right column {adding (space)"%1"}

Double Click on (Default) and write -****"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 (commend2).

no restart needed

Have Fun

hope i helped

Was this answer helpful?

400+ people found this answer helpful.
0 comments No comments

285 additional answers

Sort by: Oldest
  1. Anonymous
    2012-10-25T18:17:09+00:00

    Fair enough. If enough people tell MS, maybe they'll change it back. Mentioning it here is one way of registering your "vote". Here are some more:

    Your satisfaction Matters! Let us know your thoughts about your Microsoft experience.

    https://secure.opinionlab.com/ccc01/o.asp?id=yDnqREvN

    MS has a very large audience, so if you want your suggestion to be acted upon you need many people to make the same suggestion. So ask your friends, fiends <grin>, enemies, relatives, co-workers, strangers on the street also submit your suggestion to all of the following locations.

    Here is proof  that once in a blue moon MS does actually listen to user input about some of it’s “stupid” design decisions: http://www.theregister.co.uk/2012/05/09/visual\_studio\_11\_grey\_no\_more/

    So “.. yes Virginia …”, it is worth complaining about the stupid ribbon, or other pet peeve, they sometimes pay attention.

    But then again, when I looked at the “before” and “after” I don’t see much improvement!  I’m afraid this is a fore-runner for a “metrofied” Office 15.  Well, we’ll see.

    Another example of MS sometimes listening is found in Outlook. In 2010 MS removed the “Unread” messages view from Outlook.  In 2013 the “Unread” view is returned.


    Microsoft: Tell us what you think

    http://mymfe.microsoft.com/support.microsoft.com/feedback.aspx?formid=24

    http://office.microsoft.com/en-us/suggestions.aspx?sitename=CL100569831033&type=0


    Office 2013 / Office 365 Preview Help Forum

    http://social.technet.microsoft.com/Forums/en/officeitpropreview/threads

    MS Office 365

    http://mymfe.microsoft.com/Microsoft%20%20Online%20%20Services/Feedback.aspx?formID=210


    Office 2010

    http://mymfe.microsoft.com/Office/feedback.aspx?formID=375

    http://office.microsoft.com/en-us/suggestions.aspx 

    http://www.worldstart.com/ms-office-2010-putting-in-your-2-cents/print/ (it is something of a run around, but there are links to lots of good resources too)


    Was this answer helpful?

    0 comments No comments
  2. Anonymous
    2012-10-31T02:27:13+00:00

    that's way too complicated!

    Was this answer helpful?

    0 comments No comments
  3. Anonymous
    2012-11-04T21:44:28+00:00

    You work for Microsoft?!

    Great. Ask the design idiots why they made it so f'n difficult to open two separate windows with two different documents on the same mother f'n screen?!

    Do you jerks have any common sense in how things work in this world and why?  Whats the point of even having a site like this where a user has to edit registry to get basic use from the software that costs few hundred bucks?!

    You don't deserve to be in business, and every time someone swears at your software for not working, may it cost your corporation billions of $ per month till you fail, flop and go out of business. 

    Go run a fruit stand to figure out what people need before you bother hiring a development department to assemble it.

    Was this answer helpful?

    0 comments No comments