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-04-02T09:19:55+00:00

Hope you would like to view the files side by side for easy reference.

In MS Excel 2007, go to View >> Arrange all.

A small pop up menu will open and select Tiled or Vertical from the pop up menu.

You are done.

Hope this helps.
Was this answer helpful?

0 comments No comments
Anonymous

2012-04-15T02:28:33+00:00
1. Open all the files you want to use/view side by side ( they will be pinned to the same window like you explained     earlier)

2.   Once you have opened all the files,   view excel in FULL screne mode   (not a must,but makes it visually easier )

3. Select VIEW    tab,in the above ribbon
1. Select Arrange All (you should see a pop up menu)
TICK Windows of active workbook
1. select vertical if you want to view each file side by side (depends of personal preferance )
7, Press OK

Quick referance = Open files -> Full screne -> View -> Arrange all -> Windows of active workbook -> OK
Was this answer helpful?

0 comments No comments
Anonymous

2012-04-17T22:31:51+00:00

For Office 2010 open the desired excel spreadsheets, click the minimize button in the upper right corner left of the red X, click "View" on the ribbon and select "Arrange All", from the popup select the desired view (tiled, vertical, etc.)

Voila! Two separate screens. You can then maximize to main document housing the two separate screens.

Hope this was helpful - it took me forever to figure it out so I wanted to be sure to share...
Was this answer helpful?

0 comments No comments