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

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?

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

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.

0 comments

Answer accepted by question author

Anonymous

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

0 comments

285 additional answers

Anonymous

2012-01-13T17:30:25+00:00

What is Microsoft thinking??

I want to double click a spreadsheet and have it open in a seperate window. I do not want to open more than one spreadsheet in Excel, ever.

Why is this so hard to manage Microsoft? Registry modification for something so simple?

Excel has become more confusing and harder to use over the years. Office 2010 is not user friendly. Office was at it's best with 2003.
Was this answer helpful?

0 comments No comments
Anonymous

2012-01-13T11:07:57+00:00
Hi all

This is very simple method to open multiple windows for any application in windows 7
1. Right Click on start button
2. click properties
3. Select taskbar tab
4. In Taskbar buttons select in dropdown "Never Combine" option
5. then press ok
that's it
Was this answer helpful?

0 comments No comments
Anonymous

2011-12-30T09:42:46+00:00

You could go to the command prompt and invoke excel application 2 or more times you, need and then open your specific file from the workbook.

For instance, Office 2007 is installed on "C:\Program Files\Microsoft Office\Office12" on my Windows 7 system. I go to this folder in command prompt and type excel hit enter key, it opens an instance of excel file. Again type Excel and hit enter key, another instance opens up. This way you can have multiple instance of Excel, all in separate window that you can navigate independently.

C:\Program Files\Microsoft Office\Office12> Excel

C:\Program Files\Microsoft Office\Office12> Excel

Believe me this didnt work for Power Point.
Was this answer helpful?

0 comments No comments