- How To Open Two Excel Windows On Separate Monitors 2016
- Excel How To View Separate Windows
- How To Have To Separate Excel Windows On Two Monitors
Active6 years, 2 months ago
I want to open two (or more) excel windows on different screen (extended displays), But was not able to. I tried few solutions found on Google.
One worked, that was making changes in registry and after that checking the option 'Ignore other application that use DDE'. Now I am able to get separate excel windows but same time I get this error 'There was a problem sending the command to the program'
How to avoid this error. Can someone help me in this?
ThanksRitesh
How do I split excel onto 2 monitors. I know I need to open 2 instances but if I open a file how do I choose which instance it opens in. I know I need to open 2 instances but if I open a file how do I choose which instance it opens in. (Not side by side on the same worksheet or top.bottom.) But now, when you open two worksheets, one is on top of the other. But I found a way. First, open your first worksheet (1) you have already created the usual way. Second, go to your start button to access the excel program like opening a new worksheet. Drag the right side of the program window into the right-most monitor. Your program window should now cover most of the extended desktop, across two monitors. Open the second workbook in this same instance of Excel. Display the View tab of the ribbon. Click the Arrange All tool in the Window group. Sep 19, 2019 Open the first file in Excel and drag the window to the monitor where you want to view that file. Press the Shift Key and click the Excel Taskbar icon to open a second instance of Excel. Position that new window onto the other monitor. Use File/Open to open the second file in that window. Let us know if this works for you.
RiteshRitesh13544 gold badges88 silver badges1818 bronze badges
closed as off-topic by Andrew BarberSep 10 '13 at 3:13
This question appears to be off-topic. The users who voted to close gave this specific reason:
How To Open Two Excel Windows On Separate Monitors 2016
- 'Questions about general computing hardware and software are off-topic for Stack Overflow unless they directly involve tools used primarily for programming. You may be able to get help on Super User.' – Andrew Barber
5 Answers
This is what works for me
- Open your first Excel file and place it on the screen you want
- Open a new Excel file from the Excel icon (New instance of excel needed)
- The new file will open on top of the one you have already opened. Drag it to the other screen
- Drag the icon for the second Excel file INTO the new (blank) Excel document
Excel is a difficult beast sometimes
Brad FoxBrad Fox
What I've done is opened up one saved excel document. Then, instead of locating the second excel document and double clicking on it to open, I just went to the start button and clicked on Excel to open up a new blank document. This will give you 2 excel windows. In the 2nd excel window, open up your second excel document by going to file / open / and then browse for your 2nd excel file.Now you will have 2 excel documents, each in their own window.
ShariShari
Just follow these steps and there is no need to replace the icon (at least in Windows 7):
Start -> type “run” into the “Search Programs and files” and hit Enter -> type regedit and hit Enter:
Left column:
HKEY_CLASSES_ROOT/Excel.Sheet.8/shell/Open/commend
:Right column {adding (space)”%1″}: (be sure to include the quotation marks when typing)
Excel How To View Separate Windows
Double Click on (Default) and write –
“C:Program FilesMicrosoft OfficeOffice12EXCEL.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 FilesMicrosoft OfficeOffice12EXCEL.EXE” /e “%1″
Right Click on Command – choose “rename” and add something to the name – for example 2 (commend2).
No restart needed. You can do this for
mabarroso.CSV
files as well. Have Fun, and please share this answer with others. If the icon is not listed, you can right-click and go to Properties on any file that you wish to open with Excel, click the Change… button under the Opens With section, Browse…, look under C:Program FilesMicrosoft OfficeExcel.exe
(or under C:Program Files (x86)Microsoft OfficeExcel.exe
) and double click the EXCEL.exe
; You may have to check the box under the Opens With section that states “Always use this file type…”66522 gold badges1010 silver badges2222 bronze badges
Cody MacurdyCody Macurdy
I like the registry hack a lot, but you'll have to tweak several keys /Excel.Sheet.xx/ , and it may not work for all excel file types.
I have an alternative solution:
- Create a batch file 'open_excel_new_window.bat' with :
- Right click on an excel file, select 'open with' > 'Choose Default Program'. And browse to the batch file you just created. You may want to tick 'always use the selected program to open this kind of file'
You may repeat step 2 for all excel file types you may encounter.
There are 2 cons with this trick :
- you loose the excel icon in front of excel files (only if you ticked 'always use the selected program ..')
- there is a ms-dos windows poping-up for half a sec
The way to get rid of that is to create an exe file from your batch file : use BatToExeConverter (Freeware, dead easy to use) : select 'invisible application' and the icon you want to use for your excel files. Then, use the 'Open with' trick with your exe file.
Olivier DelrieuOlivier Delrieu
Here's what works for me (Windows 7 & Excel 2010):
- Open your first excel file
- On the task bar, right click and click on Microsoft Excel 2010
- Everytime you did this a new window appear from which you can drag the other file and view side-by-side
32.6k77 gold badges7474 silver badges8989 bronze badges
Not the answer you're looking for? Browse other questions tagged excelexceptionexcel-2007 or ask your own question.
You can quickly compare two worksheets in the same workbook or in different workbooks by viewing them side by side. You can also arrange multiple worksheets to view them all at the same time.
WindowsWeb
View two worksheets in the same workbook side by side
- On the View tab, in the Window group, click New Window.
- On the View tab, in the Window group, click View Side by Side .
- In each workbook window, click the sheet that you want to compare.
- To scroll both worksheets at the same time, click Synchronous Scrolling in the Window group on the View tab.Note: This option is available only when View Side by Side is turned on.
Tips:
- If you resize the workbook windows for optimal viewing, you can click Reset Window Position to return to the original settings.
- To restore a workbook window to full size, click Maximize at the upper-right corner of the workbook window.
View two worksheets of different workbooks side by side
- Open both of the workbooks that contain the worksheets that you want to compare.
- On the View tab, in the Window group, click View Side by Side .If you have more than two workbooks open, Excel displays the Compare Side by Side dialog box. In this dialog box, under Compare Side by Side with, click the workbook that contains the worksheet that you want to compare with your active worksheet, and then click OK.
- In each workbook window, click the sheet that you want to compare.
- To scroll both worksheets at the same time, click Synchronous Scrolling in the Window group on the View tab.Note: This option is available only when View Side by Side is turned on.Download WinZip for free – The world's #1 zip file utility to instantly zip or unzip files, share files quickly through email, and much more. Microsoft Windows 10, Windows 8, Windows 8.1, Windows 7, Windows Vista. License Agreement. For more information on how to open a zip file you can also visit our partner site www.
Tips:
- Beginning with Excel 2013, workbooks that you open in Excel are no longer displayed as multiple workbook windows inside a single Excel window. Instead, they are shown as separate Excel windows. Because workbooks don’t share the same Excel window, they are displayed with their own ribbon, and you can view the open workbooks on different monitors.
- If you resize the workbook windows for optimal viewing, you can click Reset Window Position to return to the original settings.
- To restore a workbook window to full size, click Maximize at the upper-right corner of the workbook window.
View multiple worksheets at the same time
- Open one or more workbooks that contain the worksheets that you want to view at the same time.
- Do one of the following:
- If the worksheets that you want to view are in the same workbook, do the following:
- Click a worksheet that you want to view.
- On the View tab, in the Window group, click New Window.
- Repeat steps 1 and 2 for each sheet that you want to view.
- If the worksheets that you want to view are in different workbooks, continue with step 3.
- On the View tab, in the Window group, click Arrange All.
- Under Arrange, click the option that you want.
- If the sheets that you want to view are all located in the active workbook, select the Windows of active workbook check box.
Tip: To restore a workbook window to full size, click Maximize at the upper-right corner of the workbook window.
This feature is not available in Excel for the web yet.
If you have the Excel desktop application, you can use the Open in Excel button to open the workbook and view multiple worksheets at the same time.
Need more help?
You can always ask an expert in the Excel Tech Community, get support in the Answers community, or suggest a new feature or improvement on Excel User Voice.