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
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
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

285 additional answers

Sort by: Oldest
Most helpful Newest Oldest
  1. Anonymous
    2012-03-23T13:52:02+00:00

    Hello,

             I tried what you said with Excel 2010 and it opened the same file twice on the same windows.  on different window but the same application windows.  I could not put the files side to side to do comparison.  I needed to open two different files to put side to side to compare them.

    Was this answer helpful?

    0 comments
  2. Anonymous
    2012-03-30T02:32:18+00:00

    Thanks for nice guide! It works correctly now. Actually, I never thought that it can easy like that. Great! I'm working for Tim Viec projects. So, it is really useful..

    Best regards,

    Tuyen Dung

    Was this answer helpful?

    0 comments
  3. Anonymous
    2012-04-01T21:42:35+00:00

    Difficulty: 0

    Skills Required: Using Mouse

    Time to completion: 1 Second

    Versions used to test this: Windows 7, Excel 2007

    Rightclick on the tab in the Task Bar and click on "Microsoft Office Excel 2007" to open a new workspace.

    Afterwards, simply drop in a file per Drag and Drop or use the "Data > Open"-Command to open files in the new Workspace.

    This way you don't need to edit your Registry or go the long way vie Start > Programs > etc. . I find that useful the few times I need it as it is quick, simple and does no permanent changes to your system.

    The method suggested by Bosparan is great, and it's the way I always work in Excel. Want to open a second, third, or more Excel windows?  No problem. Simply locate the Excel icon on your Taskbar, right-click, and then select/click Microsoft Excel 20xx.

    Note: After right-clicking the Excel icon on your task bar, do not click on the name of any existing or previously opened spreadsheet you see listed. Doing so will simply open that spreadsheet into the existing Excel window. To open an additional, new window, you must click the program name.

    In each Excel window, you can open one or more workbooks/spreadsheets. Drag and drop works fine, as suggested by Bosparan. Personally, I prefer to simply click File | Recent, or else File | Open and then browse to the desired file. And, of course, you can click File | New to create a new book/sheet in a particular window.

    If you want your file to reside in a specific Excel window, then you have to make that clear to the Excel program. You do this by either dragging a file into that window, or else by opening the file through that window's File tab.

    If you open an existing workbook/spreadsheet using any other method, then Excel will open the in its default window (generally the first Excel window you opened). This applies to any file you might open through the Start Menu (pinned files, etc.), My Computer / Explorer, the Excel icon on the Taskbar icon, or simply double-clicking a file on your Desktop. All those approaches will open the file in the default window.

    Was this answer helpful?

    0 comments