Home > How To > How To Open Two Excel Windows On Separate Monitors

How To Open Two Excel Windows On Separate Monitors


RSS ALL ARTICLES FEATURES ONLY TRIVIA Search The How-To Geek Forums Have Migrated to Discourse How-To Geek Forums / Microsoft Office (Solved) - Open spreadsheets in completely separate windows (16 ExcelIsFun 300,957 views630 9:57 How to open a new Excel window for a dual monitor (Windows 8, Excel 2010) - Duration: 0:47. Also see this answer. –GSerg Nov 6 '13 at 11:23 | show 8 more comments up vote 9 down vote There are certain disadvantages to having all your workbooks opened in Reports: · Posted 3 years ago Top nosparks Posts: 148 This post has been reported. navigate here

If you "uncheck" the option, Excel's behavior launches. –Sun Oct 7 '14 at 16:06 add a comment| Your Answer draft saved draft discarded Sign up or log in Sign up I know there's an excel option for "View Side by Side" this is not what I'm looking for. campbellmarilyn, - please open the multiple copies of your Outlook email Excel attachments that you would like to view side by side. See When I double-click an Excel spreadsheet, Excel opens but the document doesn't as for why. http://answers.microsoft.com/en-us/msoffice/forum/msoffice_excel-mso_other/i-want-to-open-2-excel-files-in-separate-windows/f7588d9a-3c41-466f-8f01-3b6ab9661ae3

How To Open Two Excel Windows On Separate Monitors

This will not be a good solution for me on all occasions. You just have to press Enter (to leave cell editing mode) before you open the second Excel spreadsheet. Once there, you can hold down SHIFT and then click on the icon. Find the Excel.exe application and right-click on it Choose the option to Create shortcut and send it to your desktop. Whenever you need to open a new instance of Excel

Is adding the ‘tbl’ prefix to table names really a problem? Sorry campbellmarilyn I'm not able to help sort this out for you. Just click on Start, type in Run and press Enter. Separate Excel Windows On Two Screens 2010 How do I handle this?

There must be another option somewhere that tells excel to open all spreadsheets in a different window wthout hacking the registry or ignoring DDE. Unfortunately I'd already tried that prior to posting here with bad results. Online Tech Tips Search Menu Windows Windows 10 Windows 8 Windows 7 Windows Vista Windows XP Tips Computer Tips Google Tips Internet Explorer Tips MS Office Tips Mac OS X Web http://www.computing.net/answers/office/why-cannot-i-open-more-than-one-window-in-excel/19126.html I did the registry tweak and it worked just fine.

mona is not in the sudoers file. How To Open Multiple Excel Windows In Windows 7 Great Post ! You can still split screen multiple spreadsheets within a single instance of Excel, but I find it cumbersome and not intuitive. Not saying your post is not relevant because it is, if that's what it takes to get more than one instance then we're definitely in the same ball park as to

Open Excel 2010 In Separate Windows

Same conclusion. I don't want to mess with the registry to solve this as in numerous posts. How To Open Two Excel Windows On Separate Monitors Reports: · Posted 8 years ago Top The Geek Posts: 2059 This post has been reported. How To Open Excel Files In Separate Windows By Default Highly appreciate any insights.

Carpenter Aug 7 '15 at 3:41 add a comment| up vote 3 down vote In Office 2013 they solved this issue. check over here I don't know why this isn't built in. volcy, if I'm reading these posts correctly I believe the OP is trying to achive the opposite of what you are referring to and is wanting everything to open in the Reports: · Posted 8 years ago Top Tyralia Posts: 12 This post has been reported. Open 2 Excel Documents Side By Side

Unbelievable that something this simple needs to be made so difficult and counter-intuitive. –Amos M. Upgrading from previous version of Office to 2007 may leave things in the registry that cause files to open in separate instances. With my setup of Excel 2010, if I open 3 different workbooks I get 3 separate icon windows showing on the Task Bar even tho there is only one instance of his comment is here FOLLOW US Twitter Facebook Google+ RSS Feed Disclaimer: Most of the pages on the internet include affiliate links, including some on this site.

Multiple Instances of Excel Normally, you open Excel spreadsheets by either double-clicking on them in Explorer or by navigating to them from inside Excel. Excel 2010 Open In Separate Windows By Default Thanks... Reply ruth says: September 18, 2015 at 12:08 pm Thanks a million!

If you corrupt the data in one file, you won't have to re-open all other documents from separate instances.

What should I look at specifically? Perhaps removing all office installation(s) with MS fix it and reinstalling will tune it up. I can only suggest trying one of the described ways to open files the way you need, or patching the registry. How To Open Excel Files In Separate Windows In Windows 10 Now you can avoid opening your second file from within 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, Can clients learn their time zone on a network configured using RA? share|improve this answer edited May 26 at 14:53 answered Oct 8 '10 at 20:24 Nick 369139 Cool! http://scriptkeeper.net/how-to/how-to-open-ports-windows-10.html I notice that on the taskbar(with Aero on) if I hover over the Excel Icon - I can see all the current worksheets open.

Yes, but it will make Excel take up a lot more memory... Sign in 28 Loading... Loading... ABOUT About Us Contact Us Discussion Forum Advertising Privacy Policy GET ARTICLES BY EMAIL Enter your email address to get our daily newsletter.

THANK YOU THANK YOU!!! –Michael Bray Mar 8 '12 at 17:14 5 I signed up for a super user account just to upvote this answer. Antonym for Nourish Any way to color lines in a Line command? Reply Happy says: March 5, 2014 at 5:32 am Thanks for that, it helped me :) Reply Joe says: April 21, 2014 at 6:00 pm That worked!!! What is the temperature of the brakes after a typical landing?

Reply Hewad says: June 2, 2016 at 2:58 am Superb!! Transcript The interactive transcript could not be loaded. Reply Lalitha says: October 22, 2015 at 5:42 pm The second option I have used and it worked. Bottom of the dialogue box that opens, it gives an Excel Options button - click it.

Not the answer you're looking for?