Up to three images may be included in a comment. All images are subject to review. Commenting privileges may be curtailed if inappropriate images are posted. The Tip should be fairly radically updated to take into account the two possible situations people face. After , your version will let you easily move the files about because it opens each in its own "window" filled with the full program layout.
You just grab the window and move it to the monitor you desire, or since it is a window, anywhere. Bang it on the top of the monitor and it maximizes the only way to fly. So one monitor might have one file open, the other a different one, and the third one none at all. Costs are several, but since MS is adamant about it remaining this way for, say, another years when they will surely change back to MDI and act like no one could ever want it any different Versions before killing MDI off have a different problem: You can't pull a file's working window out of the basic program's framework Ribbon or non-mendaciously named "Menu", QAT, and so on.
There are options for you though. For instance, you can do as Allen points out and open an entirely different instance of Excel. Each one, or several of them, will regard the others as nothing to do with it, as if they were even different programs the way Acrobat or Photoshop are different from Excel.
Since they are entirely separate, you can move their windows as desired. You DO lose some capability vis-a-vis copy and paste, but maybe you can live with that, and other differences. The copy and paste thing is due to Excel adding "capability" that is actually useful mostly in it to what you think is Windows copy and paste, functionality that is only available inside the program itself.
Since it doesn't recognize the other instance as itself, it only offers standard Windows copy and paste. They must be right about it being good "capability" due to the number of us complaining If you can live with that, do that. I certainly did until the fixed the SDI stuff a little. Never had two monitors while using MDI. A second way is that you can non-maximize your window. Make it as large as you like, just not formally "Maximized".
Then, here's the fun part: you can drag the border past the edge of the screen onto the second monitor. Make sure you tell Windows to treat the monitor on the left as Monitor 1, then Monitor 2 on its right or it will probably bug you each time, you know, dragging the left border left But whatever works for your comfort. Anyway, you make the program window cover some or all of each monitor.
Then when opening files you can non-maximize the files in the workspace below the Ribbon or honestly named Menu and size their windows to fit the available space Excel gives you, but keeping each to just one monitor's portion of that space. Or have a file cover both monitors giving you a majorly large number of columns to view at once! In any case, two files, one per monitor's portion, simulates the thing we poor SDI users of more recent versions have to live with.
Except you can open a file any way you like and its still in the same instance. Even though Excel has fixed SDI a little to allow proper copy and paste within a single instance, and to allow all files opened FROM INSIDE the single instance to be in that single instance their windows are SDI windows, but since they are inside the single instance, everything closes at once if you shut down the program, that kind of thing, and interaction is much easier.
But the new functions are nice. So, make one workspace out of the two monitors, then move the file windows about and you have the workspace in each as if they were SDI files moved to different monitors.
The trick of dragging borders over onto both monitors worKs for any program that lets you adjust its window size. And is occasionally quite handy, quite nice. Even if my monitors are different sizes causing oddness at the common-side corners mouse can get caught going from the bigger one to the smaller one.
Just annoyances though, not deal-breakers. Little hope, but maybe your can help. Vote here: Restore MDI When it did so, the thing that affected most people was the limited copy and paste.
Each instance regarded the others as utterly different programs, not "brothers" that should work together better. So copying and pasting formulas and formats did not work. This has since been fixed, though not very long ago about two years. Nowadays the aggravations center around the fact that in MDI, you had one ribbon, period, and a workspace beneath it.
That workspace had all your open files. Of course! So the loss here was that now each file opened each instance of Excel running has its own ribbon. So if you liked to display two files one above the other for example to make editing or comparison, perhaps, easier, now a ribbon not only is in the way, but the rows visible is reduced by any display of the ribbons.
A second aggravation experienced is in the use of VBA. Anything meant to work with more than one file suddenly had issues. You must rewrrite a fair number of things to account for those issues and overcome them. Retest, redistribute, re-explain to everyone, and so on. Further, there seems now to be some unavaoidable flickering of the files in the display area as the macros move back and forth, flickering which never occurred in MDI.
Recently a small amount of the default opening behavior was fixed. Initially, the only way to open two files in the same instance was to use File Open in the chosen instance. This has been partially fixed in that one can take a file from Explorer and drag it onto the desired instance of Excel and it will open in that instance really, not just seeming to: according to Task Manager anyway.
But it won't let you drag and drop from something like even Outlook, a family product. Even the File Open method and the fixed drag and drop method will not overcome the extra ribbon or the VBA issues, apparently. So, if you have a version older than Excel 13, or do not use functionality that is affected, never noticed the "all have Ribbons", or do use functionality that was affected but has since been fixed, you might not realize any of this happened.
Hence the confusion. Wyatt DID allude to it briefly his 4th sentence but did not expand on it. As you can see, expanding might not really have fit the scope of a "tip" rather than a "dissertation" And this tip must've been written prior to fixing that horrible copy and paste business. No explanation given by MS has ever made sense. How do you drag one screen to another screen, so you can view 2 open excel sheets at the same time, but on different screens? This is NOT want I want.
I need two sheets within one file, seen side by side, horizontally or vertically. I was able to do this in older versions, but not in anymore. Can you help? Oh dear, that does sound odd. Have you tried tiling them or changing the arrangement? I use a lot of spread-sheets in my work and I have a problem that Excel opens each subsequent file tiled below the previously opened files.
This means that I have to continually move the sheet up to ensure that I can see the tabs at the bottom of the spread-sheet. If I have say 5 sheets open, the tabs of the last sheet are not visible, How do I get Excel to open all sheets at the top of the screen and not in tiled view? Thanks for your question — unfortunately as far as I know it always opens them all slightly overlapping so you can see how many you have and clock on the ones underneath — not helpful, I know.
Instead of going to one toolbar for formating I know have to unhide and view one for each worksheet. Previously opened MS word and excel documents will be hided and I see only the final one. Have you followed the instructions in the article, this should allow you to see both side by side or one above the other on your screen. In my view lots of features are worse than before; the definition is less clear and the new feature with separate workbooks and headers is very confusing if you work with multiple books.
I just want to take a moment to say thank you for taking the time to post. I often Google solutions and people think I am a wizard because of awesome people like everyone here who help me look good and intelligent. Figured I needed to finally recognize that and commend you all for contributing to this vast world of information with positive and GOOD solutions.
Thank you all for sharing!!!!! How do you do this with Excel If I have several worksheets open within the same workbook, they each have a ribbon. Just updated from to I want to have exactly the option above…one instance of Excel, several worksheets open at once, so only one ribbon at the top taking up screen space.
You are commenting using your WordPress. You are commenting using your Google account. You are commenting using your Twitter account. You are commenting using your Facebook account. Notify me of new comments via email. Notify me of new posts via email. This site uses Akismet to reduce spam. Learn how your comment data is processed. LibroEditing proofreading, editing, transcription, localisation proofreading, editing, writing, transcription and localisation.
How do I view two sheets of an Excel workbook at the same time? How do I view two Excel spreadsheets at a time? If you have two spreadsheets open in, say, Excel from which these screenshots are taken, but the process is the same for Excel , and , pressing this button will show you both spreadsheets, one above the other this always reminds me of playing competitive driving games on the games console : You can see that the Synchronous Scrolling button is highlighted in the image above.
Read on for that option … How do I view two spreadsheets next to each other or in a tiled layout? All of my other examples feature two spreadsheets, but to demonstrate the Tiled option, here are four spreadsheets: Note that the spreadsheets arrange themselves in the order in which you have them open, so if Spreadsheet 4 is the last one you looked at, that will appear top left.
Arrange all — Horizontal If you choose the Horizontal option in Arrange All , your spreadsheets will appear on top of each other, with the split between them horizontal: Note here that I had Spreadsheet 2 active visible when I chose this option, so it appears at the top.
Arrange All — Vertical Choosing the Vertical option in Arrange All gives you the two or more spreadsheets arranged next to each other, with the split between them vertical: This is how I prefer to view them.
Arrange All — Cascade I find this one a bit odd. Like this: Like Loading Liz at Libro September 17, at pm Thanks for your comment — you can also use the New Window option for doing this, which is close to the Side By Side etc.
Sarah November 21, at am Thank you for this!!!! Pingback: How do I view two sheets of an Excel workbook at the same time? LibroEditing proofreading, editing, writing. Windows Registry Editor Version 5. Tuesday, February 7, PM. Just drag it. You could open another Excel and drag the file to it.
Wednesday, April 11, PM. Studies have shown that having an additional monitor increases the productivity by 20 to 30 percent Source: NY Times But some applications like MS Office Excel, even though you open multiple files, they are all from the same instance of the application. Option B : They key here is, the application has to be loaded as separate instances.
Thursday, April 19, AM. Running Multiple Instances of Excel Be careful in changing the settings, could cause problems. Proposed as answer by gcallantii Monday, August 12, PM. Friday, April 20, PM. Wednesday, May 9, PM. I think the problem was in opening two instances. Your suggestion states to "simply open two instances" and drag one to each monitor.
I used to be able to do this in earlier versions of Excel but can no longer do so with The link you provided is for so I'm not sure what the story is for I did have luck one time but I don't know what I did so it is possible.
I have been able to do it going through the start menu but that's a bit clunky. Both work like a charm. Thank you! How do you enlarge a single instance across two monitors? I too have the same issue. I link a number of spreadsheets and I can't connect cells from spreadsheets in separate instances of excel. Worked perfectly with the above directions. Life saver. Friday, May 25, PM. Worked perfectly!
Thanks for the very clear instructions! Friday, August 17, PM. Friday, August 24, AM. A real "duh" moment that I didn't figure this out sooner too Thanks Scotslad!!!! Monday, August 27, PM. Thanks so much for that Tuesday, September 4, PM. Thanks, that worked for me! Friday, September 28, PM. Tuesday, November 27, PM.
Repucci 0. In my opinion, this is the best solution to this problem. Thanks Colin! Wednesday, December 19, PM. Wednesday, January 9, PM. Worked great! Monday, February 4, PM. Saturday, July 6, PM.
Thanks again! Monday, August 12, PM. Tuesday, September 24, AM. The easy way to open two or more excel files separately. This is what works for me just figured it out : 1. Create shortcut on Desktop 2. Open your first Excel file and place it on the screen you want 3. Open a new Excel file from the Excel icon on Desktop 4. Drag it to the other screen 5. Two separate screens. Thursday, October 31, AM. Thanks sooo very much - been wanted to use this for days :. Sunday, November 3, AM.
Take Care. Friday, November 8, PM. Monday, November 11, PM. Thursday, November 21, PM. Thank you, i success following this instructions. Really good. Tuesday, December 3, AM. I took this from another site, it worked for me in XP. Run regedit first. Ok, this will be slightly complicated If something breaks I don't take responsibility! Here's a screenshot of the final way it should look note that my excel install directory will likely be different than yours : Once you do this, you should be able to double-click on excel files, and each one will open in a new window.
Friday, December 6, PM. Thank you Dale, it works for me. It is really appreciated. Cheers, Mike. Monday, December 23, PM. Click here then click there - right-click left-click hold down the CTRL key What happened to the ol 'click a file's icon it opens the file, click a different file's icon, it opens that file in another window', and why is it so bloody hard to restore this functionality?
Microsoft you never fail to disapoint, just sayin.. Friday, January 3, PM. Thank you so much, Dale. I can do it successfully. Regards, Nay. Friday, January 10, AM. I do want to thank those who share. Monday, January 13, PM. Thursday, January 16, PM. Friday, January 17, AM. Thanks for posting this. You just saved me a good amount of time of searching for an answer. Thursday, February 6, PM. Thanks, simple enough and works for me Friday, February 28, PM.
Wednesday, March 5, AM. This is a workaround and is not a seamless automated transition from default. Saturday, April 5, PM. Dear Friend, thank you very much , this is very useful advice. Thursday, June 12, AM. Sunday, June 29, AM. Tuesday, July 1, AM. Everyone else should delete their responses.
Monday, July 14, PM. My understanding is that this is not a Windows version issue, it is a problem with Excel that they have recently fixed Excel I was able to get it open twice, on separate screens and with separate close functions, by holding down the alt key and right clicking on my pinned Excel icon. You then select the excel icon in the list mine is Excel and a new instance opened right up.
I found the instructions granted for on the Office Blogs site and made it work. Hope this helps anyone who's still looking for answers. Tuesday, July 22, PM. Thank you, Sir C Mac - Works a treat! Just a typo in both 'Left column:' lines. Should be command not commend Cheers Max. Thursday, July 31, AM.
Excellent, such a simple solution and I struggled for this so much!!! Tuesday, August 5, PM. Wednesday, August 13, PM. You are a life saver! Friday, September 5, PM. You are too extreme. Thursday, September 25, PM. And open the second file from the Excels menu File Open If it helps dont read the rest of this post.
Quote from helpful Dale which is already done in your default settings. Edited by pozitrone Tuesday, September 30, AM. Tuesday, September 30, AM. Exactly what I wanted! Wednesday, November 12, PM. Works great. Proposed as answer by jharold12 Friday, February 6, AM. Friday, February 6, AM. Open the first document. Then from your Excel shortcut open a new excel document.
From there just open the second one. It will stay in a separate window that you can drag it anywhere you want. Tuesday, February 17, PM. Monday, March 9, PM. It worked. Thank you very much.
I've been wracking my brain on how this is done. Tuesday, March 10, PM. Sunday, March 22, PM. The answers provided above by Dale and other people, makes absolute sense but I think you don't. Tuesday, March 24, PM. Super helpful -- thanks Dave. Tuesday, April 14, PM. Wednesday, April 29, PM. Brett This link worked for me with a slight modification to point to the correct excel. Friday, June 12, PM. This has been killing me for years, and I'm so glad I finally searched to see if there was a way to do this.
I can't begin to describe how happy and grateful I am. Thank you so much. Monday, June 29, PM. Wednesday, August 26, PM. I just tested this and it does work. Wednesday, October 14, PM. Works great, gives me the option of opening in same instance of Excel by double-clicking the file, or different instances by using Send To that I can put on different monitors, depending on what I need to do. Monday, October 19, PM.
Saturday, November 28, PM.
0コメント