Home > How To > How To Have 2 Excel Windows Open At Once On Two Monitors

How To Have 2 Excel Windows Open At Once On Two Monitors

Contents

What do I need to do? Make sure you are in window mode and not have your window maximized. 2. still had to tweak it to make it work.. If you want to double-click the file from Windows Explorer, follow the instructions at: http://www.drewery.net/blog/2006/08/29/utilising-dual-monitors-with-microsoft-excel-2003

And from one of the user comments to the blog above that may help: "If you’re this contact form

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. Join and Comment By clicking you are agreeing to Experts Exchange's Terms of Use. I love opening up the ancient threads, lol. 0 Habanero OP B-C Aug 6, 2010 at 10:21 UTC I was bored... I found this at the following web address: http://answers.microsoft.com/en-us/office/forum/office_2010-excel/open-more-then-one-session-of-excel-in-office-2010/cd73086f-0679-4ef6-8e55-941183bf9d5c?msgId=d294998e-549b-4be1-8749-690e1f87711e Friday, February 15, 2013 2:26 PM Reply | Quote 0 Sign in to vote This works great!

How To Have 2 Excel Windows Open At Once On Two Monitors

I have this option marked, but it's not what I need. Seems it's one or the other. VBA could be used to rename, open then later close and restore original name. .. Any other feedback?

It can be done manually, but I'd like to be able to set a default to open a new instance when I open a file. Send No thanks Thank you for your feedback! × English (United States)‎ Contact Us Privacy & Cookies Terms of use & sale Trademarks Accessibility Legal © 2016 Microsoft ERROR The requested Thanks again, Regards, Renatoabc Thursday, July 07, 2011 1:59 PM Reply | Quote 0 Sign in to vote Hi Jim, Thanks for the help, but this option is already marked and How To Open Two Excel Files Side By Side In Separate Monitors 2010 Renatoabc Edited by renatoabc Tuesday, December 27, 2011 8:35 PM Tuesday, December 27, 2011 8:33 PM Reply | Quote 2 Sign in to vote I've been trying to figure this

Microsoft Office > Excel IT Pro Discussions Question 1 Sign in to vote Hi, I have Win 7 and Office 2010 Professional. go here and click fix it... Top of Page 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. All rights reserved.

and it is awesome! View Two Excel Files At Once On Two Monitors If the worksheets that you want to view are in different workbooks, continue with step 3. If the worksheets that you want to view are in different workbooks, continue with step 3. In that section check the setting for "Ignore other applications that use DDE".

How To Open Two Excel Files Side By Side In Separate Monitors

On the View tab, in the Window group, click View Side by Side . All Rights ReservedAd Choices The information on Computing.Net is the opinions of its users. How To Have 2 Excel Windows Open At Once On Two Monitors Marked as answer by renatoabc Tuesday, September 20, 2011 9:56 AM Thursday, July 07, 2011 2:19 PM Reply | Quote 0 Sign in to vote Hi Alexander, Thank you very How To Open Excel Files In Separate Windows By Default most no longer work in 2013+ 0 LVL 14 Overall: Level 14 MS Office 9 VBA 6 MS Excel 6 Message Active today Expert Comment by:DrTribos2015-09-29 Comment Utility Permalink(# a41015734)

Creating your account only takes a few minutes. weblink Tips In Microsoft Excel 2013 and Excel 2016, workbooks that you open in Excel are no longer displayed as multiple workbook windows inside a single Excel window. Your cache administrator is webmaster. And for the sake of completeness: You can achieve the same behaviour by disabling DDE: File|Options|Advanced - set the checkbox at "Ignore other applications that use DDE" Then you don't need Excel View Side By Side Greyed Out

In Excel, click on the Office Button 2. When I oppen multiple Excel 2010 files there is only one instance of Excel, what means that if I minimize the Excel windows I can see no other Excel files on Anyway, thanks very much to Alexander Freudenberg who solved the problem about the instances, but keep this as a free advice, BTW:There is another way for the same result, if you navigate here Excel Options | Advanced and under "Display" checkmark "Show all windows in the Taskbar" '--- Jim Cone Portland, Oregon USA http://www.mediafire.com/PrimitiveSoftware (Special Print add-in: print columns side by side / rows

All solutions are welcome. How To Open Multiple Excel Windows In Windows 7 All solutions still welcome. Instead, they are shown as separate Excel windows.

But this is only true when you open two files from the same instance of Excel.

See More: Why cannot I open more than one window in Excel Report • #1 mmcconaghy June 22, 2014 at 07:52:25 Not sure what you mean, but on the Windows toolbar, Easiest way I know.. Proposed as answer by Zach Hebein Wednesday, May 23, 2012 12:56 AM Wednesday, May 23, 2012 12:56 AM Reply | Quote 2 Sign in to vote If you run into this Separate Excel Windows On Two Screens 2010 However in MS Office Excel 2013 I am unable to do this.

Tip: To restore a workbook window to full size, click Maximize at the upper-right corner of the workbook window. But I cannot select more than one to open at a time. David Miller (dlmille) Intro Have you either copied sheets to a new workbook, and after having saved and opened that workbook, you find that there are links back to the original http://scriptkeeper.net/how-to/how-to-open-ports-windows-10.html Operating Systems ▼ Windows 10 Windows 8 Windows 7 Windows XP See More...

To scroll both worksheets at the same time, click Synchronous Scrolling in the Window group on the View tab. Top of Page 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.