Using a Single Instance of Excel with Two Monitors

Hi rick,
I think Allen Wyatt’s higher Excel version of this blog says approximately the same (h t t p s : / / excelribbon.tips.net/T006199_Using_a_Single_Instance_of_Excel_with_Two_Monitors )

I think when anyone talks about these things, no one is ever quite sure what the other is talking about.
Versions can confuse a bit as well I think.. For example , I think since 2013 each workbook is displayed in its own application window. (h t t p : / / w w w . eileenslounge.com/viewtopic.php?f=30&t=31996#p247993 )

I have older versions ( and I seem to be able to mess around with the icons top right to get two workbooks shown inside a large outer window (FiddleAroundTopRightWindowButton.JPG : h t t p s : / / imgur.com/U4ZSL1v )
( In that last screen shot I am using the same instance of Excel for both workbooks. )
My guess is that Allen Wyatt is talking about the situation of when you have two monitors, in the extended monitor option , not clone mode , like this, I expect , h t t p : / / w w w .repeatsoftware.com/Help/MultipleMonitors.htm
If in that situation you fiddle around with where the main outer window and the inside ones are, then you can probably get a situation where different workbooks appear to be on the different monitors.
( I almost always use two monitors. Even If I am travelling with just a Lap Top: - I have a cable with me and set up the extended monitor option using any screen I find, such as a television screen. I like to have a spreadsheet on the big Telly screen, and the VB Editor in front of me on the lap Top. )

I seem to be able to do what Allen Wyatt is suggesting with fiddling about a bit. ( I couldn’t find the “Arrange Windows dialog box” that he mentions. I don’t seem to need it, - I seem to already have enough flexibility to change window size and drag different windows around between screens.

Further more, if I right click anywhere in my desktop and fiddle around with settings and options, then I can usually find one to change the relative position of my monitors, so that allows me to decide where the ribbon ends up, (MoveMonitors.JPG : h t t p s : / / imgur.com/SeFd8Gp )

As I usually have a large screen, It is easier for me to move the workbooks to convenient places there, in the large screen, and so I save the lap top screen for things like the VB Editor window.
Possibly what Allen Wyatt is suggesting would be useful if I had two fixed screens which were similar size, but not too large, and I wanted specifically to see just two workbooks. Then I could fiddle around until each was almost filling each screen.

I think, rick, to summarise, Allen is talking about the situation when you have two workbooks open in the same instance of Excel and you have two monitors. Then he is suggesting a way to fiddle around so that each workbook comes close to appearing to be in a separate monitor.
If you have a big enough single screen, ( either as your only screen , or as I do , as one of two monitors ), then what Allen is suggesting here would be less necerssary

Alan Elston

Hmm... Not sure if I am missing something here but i just open two (or three or four or five or....) workbooks and just place them all around as i need them. I can scale and code and work with any of them as i need to like any workbook.

oh - wait, this was for older versions of excel - never mind, sorry

Hmm... Not sure if I am missing something here but i just open two (or three or four or five or....) workbooks and just place them all around as i need them. I can scale and code and work with any of them as i need to like any workbook.