How to open 2 Excel documents on 2 screens? Solved/Closed

Question

Hello,

I have a little problem, I have two screens for working.

Currently, when I open two Excel documents, they open in the same window (Excel session).

I would like to open these documents in two different Excel sessions so that I can have one document on each screen.

Currently, the solution of opening two blank Excel sessions and then opening the documents does not appeal to me.

Thank you for your help.

vaco917 · Accepted Answer

Hello,

There's a much simpler solution than going to delete things on the PC.

Open an Excel document
Right-click on the Excel icon in the taskbar
Click on Microsoft Excel, above "Pin to taskbar"
Another Excel window opens where you can open another document

That's it
See you!

Srg2 · Answer

Otherwise, you open the first file by double-clicking it, then you start Excel (Start Menu/Office/) by itself, and then you look for the second file through 'File/Open' and search for it in the directory of your drives.

lamuz85 · Answer

Thank you f894009, but as I told you, I am not going to do that for my 500 users.

Srg2, as explained above, I do not want to implement your solution.
We must consider that the user is "dimwitted"; explaining your manipulation to them will not satisfy them.

I will still test your solution f894009 on my workstation.

GhosTSharK · Answer

The REAL solution is found at Microcrotte :D  http://support.microsoft.com/kb/2551928/en  And if you want the action to be default... don't forget to click the "Default" button in Folder Options>(.XLS and .XLSX)>Advanced> (Select "Open in a new window") and then the "Default" button.  Miracle... It works!!!! Thank you who????....

Depassage · Answer

Modify the registry keys as follows:

Press [Windows]+[R], type REGEDIT, and click OK

First sequence

Expand the key HKEY_CLASSES_ROOT \ Excel.Sheet.12 \ Shell \ Open
Delete the DDEEXEC key by right-clicking it and selecting Delete
Enter the COMMAND key
Notice the presence of a value "(Default)" and a value "command"
Right-click on the value "command" and choose Delete
Double-click on the value "(Default)"
Add a space followed by "%1" (with the quotes) at the end of the line so that the data looks like:

"C:\Program Files\Microsoft Office\Office12\EXCEL.EXE" /e "%1"
Second sequence

Expand the key HKEY_CLASSES_ROOT \ Excel.Sheet.8 \ Shell \ Open
Delete the DDEEXEC key by right-clicking it and selecting Delete
Enter the COMMAND key
Notice the presence of a value "(Default)" and a value "command"
Right-click on the value "command" and choose Delete
Double-click on the value "(Default)"
Add a space followed by "%1" (with the quotes) at the end of the line so that the data looks like:

"C:\Program Files\Microsoft Office\Office12\EXCEL.EXE" /e "%1"

Close REGEDIT

Now, if you double-click on two XLS or XSLX files on the desktop or in Explorer, they will open in two separate windows.

Sof · Answer

I'm taking the solution from an internet user that worked for me:

"mozisII wrote:

1 year later:

I found it! To open a new application (window) of Excel every time you double-click on an xls file:
* Folder options
* file types
* select "xls" SAME FOR "xlsx"
* advanced
* select "Open"
* Modify...
* Uncheck "Use DDE"
* At the end of the Application used line add "%1" (with quotes). The line becomes something like:

"C:\Program Files\Microsoft Office\Office10\EXCEL.EXE" /e "%1"
The difference is that for me I have /dde at the end and not /e, I simply added "%1" with a space and it worked
* OK

To revert back to the previous setting:
* Go to the modification of "open" for xls
* Remove the "%1" at the end
* Check DDE if it's not already the case
* enter in "DDE Message": [open("%1")]
And "

Big · Answer

For Windows 7 with Office 2007 or 2010

You need to change the following registry keys.
HKEY_CLASSES_ROOT\Excel.Sheet.8\shell\Open\

Rename the key ddeexec to ddeexec.old

In the command key
Modify the command key by changing the /dde at the end of the line to /e "%1"

Do the same for the key
[HKEY_CLASSES_ROOT\Excel.Sheet.12\shell\Open\
Rename the key ddeexec to ddeexec.old

In the command key
Modify the command key by changing the /dde at the end of the line to /e "%1"

zouko · Answer

To open two Excel files at the same time, you need to follow these steps:
1) Have two Excel files (logical)
2) Open one of the two Excel files and wait for its content to be displayed
3) Now open the Excel application again either via the shortcut on your desktop or directly in the program bar on your computer.
4) Now open your second file from this new Excel window. Simply go to File > Open... and navigate in the window to your file.
5) You now have two Excel files displayed at the same time!
If you've been looking for this tip for a long time, feel free to share it with those around you.

alunel · Answer

Hello,

A solution to avoid complicating things by opening 2 instances and pulling from the 2nd file (which is problematic when it's attached to an email or on a website) or not having to tweak the registry is to install the app found here:
http://blog.aube-tech.com/2013/08/excel2session-ouvrir-ms-excel-dans-2-fenetres-differentes/

See you later!

tinopluss · Answer

Hello,

Here’s a method if you’re not the Administrator of your machine and therefore don’t have access to regedit, which is often the case at work!

Create a .bat file with the following line inside, adjusting the location of the Excel executable:

start "" "C:\Program Files (x86)\Microsoft Office\Office14\EXCEL.EXE" %1

And set the .xls, .xlsx, etc. Excel files to open with the previously created .bat file; they will launch in a new window.

There you go :)

Chewby · Answer

Right-click on the WINDOWS taskbar (in an empty area) - Show windows side by side

Bouh · Answer

The Bat solution is very good. By redirecting the opening of xls files to Batch and adding an Excel icon, it's perfect.
The other solution, which involves opening a second Excel window, is what I used until now.
But I wanted to clarify: everyone seems to forget the middle click integrated into all mice nowadays.
Let me explain: once the first Excel file is open, by middle-clicking on the Excel icon in the taskbar, a new window opens. You just have to drag the second file to be opened into it. It's the same thing as mentioned above but with fewer clicks, fewer words, and easier to grasp for a beginner.

Hamid · Answer

For MS Office 2010  File-->Options (or: Alt+F+O)-->Advanced Options-->Display: check the box "show all windows in the taskbar".

How to open 2 Excel documents on 2 screens?

13 answers

Youtube music

Transfer data to a new pc

My computer stays connected for very little time

Printer port error on canon ts3100 printer

Xiaomi redmi note 140 -

Which pc to choose

Connecting a sony handycam video 8 ccd f555e to an hd tv

New simplified cancellation feature for online purchases

Downloaded .rar file becomes .htm when finished

Self-invoking js function