Home > How To > How To Open Excel Files In Separate Windows By Default

How To Open Excel Files In Separate Windows By Default


Number three - Excel option in the Send To menu If you often have to open two Excel windows simultaneously, see this advanced shortcut solution suggested on the forum. Good luck!!! 1. If you want to do the same thing for Excel 2007 files, you'll need to make the changes to the HKEY_CLASSES_ROOT\Excel.Sheet.12 key. Anyone have a solution to the same issue? (i.e. - opening two .ppt presentations into two separate PowerPoint windows on two different monitors, in one machine?) Thanks! .James. have a peek here

Thursday, February 10, 2011 8:01 PM Reply | Quote 0 Sign in to vote EVERYBODY in this post gave wrong reply!!!!!!! It only works if the user spreadsheet is the same day after day. OR RIGHT click on the Excel icon pinned to taskbar and LEFT click Microsoft Excel 2010will also open another instance. Tuesday, March 24, 2015 5:35 PM Reply | Quote 0 Sign in to vote Super helpful -- thanks Dave Tuesday, April 14, 2015 3:45 PM Reply | Quote 0 Sign in

How To Open Excel Files In Separate Windows By Default

Then, we can "Restore Down" each file and move them about the monitor and across multiple monitors. For example you can't do a VLOOKUP or even choose a cell value from the other window. Monday, February 04, 2013 4:09 PM Reply | Quote 0 Sign in to vote If you have Windows XP, here is what you can do: Download Excell Viewer (google it) and Thursday, October 31, 2013 6:39 AM Reply | Quote 0 Sign in to vote OMG!!!

Therefore I can't open through my documents. He was awarded the 2009 MVP award from Microsoft for his contributions in forums and blogs and is enjoying the new addition to his family. Pasted from Proposed as answer by gcallantii Monday, August 12, 2013 4:32 PM Friday, April 20, 2012 3:53 PM Reply | Quote 0 Sign Prevent Multiple Instances Of Excel 2010 In my case it has the "Use DDE" box checked (and below the DDE message Open "%1").

You then select the excel icon in the list (mine is Excel 2010) and a new instance opened right up. Excel 2010 Open In New Window Name E-mail (not published) Unfortunately, due to the volume of comments received we cannot guarantee that we will be able to give you a timely response. Great solution and easy; thanks krystle!!!!!! :-) Wednesday, January 09, 2013 4:25 PM Reply | Quote 0 Sign in to vote Worked great! What is a person who fakes responses on a survey?

Next you'll need to rename the ddeexec key here to ddeexec2 or something else: HKEY_CLASSES_ROOT\Excel.Sheet.8\shell\Open\ddeexec This will make the change for the Excel 97-2003 filetype. Open Excel File In New Window You just saved me a good amount of time of searching for an answer. To access this setting, open Microsoft Excel. Thanks Reply Irina Pozniakova ( Team) says: September 29, 2016 at 10:03 am Hello Alan, I'm sorry, we don't know what may be causing these differences.

Excel 2010 Open In New Window

By using the start menu to open excel again, it opens as a "new instance" Reports: · Posted 8 years ago Top Tyralia Posts: 12 This post has been I can try it at home, and let you know if this method works on Win 7. How To Open Excel Files In Separate Windows By Default This will let you have two windows of workbooks side by side and independent of each other.As an alterantive, if you want to see two different workbooks in the same window, How To Open Two Excel Windows On Separate Monitors This is a problem for me because I review a lot of documents that are e-mailed to me - and I don't necessarily need to save them.

Looking at spreadsheets in two different windows makes many Excel tasks easier. navigate here So naturally the users experience counts in my book and to try to help them out I created a shortcut on their desktop in Win7 and changed the shortcut key to Up for that? Minimize this windowand move it to the right screen. Separate Excel Windows On Two Screens 2010

ABOUT About Us Contact Us Discussion Forum Advertising Privacy Policy GET ARTICLES BY EMAIL Enter your email address to get our daily newsletter. This site is completely free -- paid for by advertisers and donations. I would have many files open, in only one "window" or instance of Excel. Check This Out Click the Office Button and then click Excel Options, which is down at the bottom right side of the menu.

Now all the Excel files will be opened as separate instance and you can move the Excel files individually across the monitors. Open Excel Workbooks In Separate Windows 2010 Drag thefirst Excel file that you wantto openinto the first Excel window and drag the second Excel file that you want to open into the second Excel window. I'm sorry that my instructions are not more clear or easier to understand, but I'm short on time and really wanted to share my find.

If your mouse has a wheel - click on the Excel taskbar icon with the wheel.

I know it's been a while, and you'll probably never see this, but thanks. Obviously opening a document that way would display the document in that given screen. All rights reserved. How To Open Multiple Excel Files In One Window share|improve this answer answered Sep 26 '12 at 7:51 HaydnWVN 3,02531441 add a comment| up vote 0 down vote I had the same problem.

Edited by Betlista Tuesday, July 01, 2014 8:52 AM reply not visible well Tuesday, July 01, 2014 8:50 AM Reply | Quote 0 Sign in to vote Thank you. I quit reading through posts at the time of frustration. Ken Blake, Microsoft MVP Wednesday, June 01, 2011 12:13 AM Reply | Quote 0 Sign in to vote Hey all, First let me say, I am not on a Mac, Another neat trick someone mentioned was opening the first document via the start menu or desk top than on the bottom task bar hover your mouse over the Excel icon and

Open the second Excel file from within the separate window and move it to the left screen.You can open as many files and separate windows as you need using this method. You can right-click the file you want in a new instance, and choose to Send To -> Excel. To find out more and change your cookie settings, please view our cookie policy. You can usually open another instance of Excel by browsing through the Start Menu -> Programs -> Microsoft Office -> Excel.

Reply Jeremy says: July 23, 2015 at 10:02 pm Sure, they separate, but are still stuck within the confines of that workbook. I can't begin to describe how happy and grateful I am. Friday, February 28, 2014 3:30 PM Reply | Quote 0 Sign in to vote excellent..thanks for sharing the simple solution. Install all Windows and Office 2003 updates.

I am using XP (with Office 2010) at work, and that is mainly what I needed to open multiple instances up for, I don't know if it works on Windows 7, One of them is selecting the "Ignore other applications that use Dynamic Data Exchange (DDE)" option in Advanced Excel Options. You will then just be able to double click on an excel document and it will open a seperate isntance of excel. Windows menu...You can both open the excel sheet on the same instance as default by excel or seperately it works both way.Tell me how it went on...Dwij 0Votes Share Flag Collapse

Wednesday, April 11, 2012 3:14 PM Reply | Quote 3 Sign in to vote If you are working almost the entire day in front of your computer at your office with Change the Code, Change the Sequence: Cops What Dominion Cards use victory tokens? Reports: · Posted 8 years ago Top Tyralia Posts: 12 This post has been reported. Has anyone had any luck doing this?

Press and hold the Shift key on your keyboard and click the program icon on the taskbar. Now, I can't say anything about other people and variations on their PCs: results might differ.