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
    2011-11-22T15:29:48+00:00

    There is a much easier way to do this w/out going into your registry.  In windows 7, in your task bar you have an icon for excel, it helps if you pin the icon to the task bar but it is not necessary.  

    Depending on if you have your computer set to display the most recently opened documents you can perform the following:

    Step 1

    Right Click on the Excel Icon in your Task Bar

    Step 2


    Select the first sheet that you wish to view or a simple select Microsoft Excel for a new blank sheet

    ***Note-the icon keeps the 10 most recent entries***

    Once wither your most recent document or the blank sheet is open (depends which you select from the pop up menu)

    Step 3

    Right Click on the Excel Icon**(in the Task Bar) a second time**

    ***you will then have the option to select the second sheet (if its listed)that will open in a new window, or you can simply selectMicrosoft Excel and it will open you a blank sheet in a new window***

    Step 4

    You now have two open windows with two separate excel sheets.

    Once you have your Blank Sheet, then in that window you can open up any other sheet that you wish.

    If you still have questions, visit https://newwaveit.com/Contact_Us.html and select Contact Me and post your question,  there's never a charge for replies.

    Yaser Ebrahimi

    http://www.newwaveit.com/

    Was this answer helpful?

    0 comments No comments
  2. Anonymous
    2011-11-22T21:10:17+00:00

    This does NOT work.  I am also looking for a solution to have two different "Excel Workbooks" open in two completely sepereate Excel windows (two different monitors if you will!)  Not two spreadsheets open within a single excel window or workbook, or snapped to fill the window sided by side, or one on top of the other, etc. I want to put an excel workbook on my monitor on the left, and one on the monitor on my right!  I'm working with Windows 7 professional, a brand new PC, and Office 2010 Professional.  I have been curious about that for years. I just happened to stumble upon this particular thread in the answers forum as I was going to post for something else...which I had forgotten about until now because I was distracted by all these posts...most of which don't work.  I am assuming the person posting registry specifics knows what they are talking about.  I'm not that brave to attempt changing my registries...I just figured an actual Microsoft person would have posted by now the real answer...but I have not read pages 3-10 yet, I read 1-2 then skipped to 11...still doesn't seem to be a true answer to this question. Siiiiighhhh!

    SideNote: I did just notice that my new microsoft touch mouse for windows 7 does not control the horizontal movement of this particular dialogue box, which I find amusing.  And I do not understand why this dialogue box even has horizontal scroll, I have 22" wide monitors yet instead of filling the screen, it resorts to a horizontal scroll that shows the 2-3 cut off letters...wow!

    Was this answer helpful?

    0 comments No comments
  3. Anonymous
    2011-11-22T21:17:06+00:00

    Hey, it does but it is really quirky!!

    Pin your Excel icon to your taskbar (windows 7 right)

    Then, open one instance of Excel

    RIGHT click the Excel Icon in your Task Bar

    Select  MICROSOFT EXCEL

    You should now have 2 windows Seperately opened with Blank content.  Put one on each monitor as you wish and then in the blank sheets, open your saved workbooks accordingly.

    It works, its just really Quirky and you have to click exactly what I listed above.

    I can send you screen shots if you send me an email.

    Thanks

    Yaser Ebrahimi

    http://www.newwaveit.com

    Was this answer helpful?

    0 comments No comments