April 9, 2024
Contribute to the Microsoft 365 and Office forum!
Click here to learn more 💡
May 10, 2024
Excel Forum Top Contributors:
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
Report abuse
Thank you.
Reported content has been submitted
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.
Report abuse
Thank you.
Reported content has been submitted
858 people found this reply helpful
·Was this reply helpful?
Sorry this didn't help.
Great! Thanks for your feedback.
How satisfied are you with this reply?
Thanks for your feedback, it helps us improve the site.
How satisfied are you with this reply?
Thanks for your feedback.
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
Report abuse
Thank you.
Reported content has been submitted
409 people found this reply helpful
·Was this reply helpful?
Sorry this didn't help.
Great! Thanks for your feedback.
How satisfied are you with this reply?
Thanks for your feedback, it helps us improve the site.
How satisfied are you with this reply?
Thanks for your feedback.
Question Info
Last updated May 9, 2024 Views 2,627,651 Applies to: