You should see the Arrange Windows dialog box. Your program window should now cover most of the extended desktop, across two monitors.
(Drag the title bar of that program window into that monitor, if necessary.) Make sure the program window is fully visible in your left-most monitor.(Click the Restore button, in the upper-right corner of the program window, if necessary.) Make sure that the Excel program window doesn't fill the entirety of a monitor.Open one of the workbooks in Excel, as you normally would.What would be ideal is if Joe could open both workbooks in a single instance of Excel and still have the two workbooks appear on their own monitors.Īssuming that you've got Windows configured so that it views the two monitors as a single desktop, there is only one way to do this that we've been able to discover. The problem with that, however, is that he cannot easily copy and paste information from one workbook to another. He can do this, but only if he opens two instances of Excel. He would like to have one Excel workbook appear on one of the monitors and another workbook appear on the other monitor. Joe has a system that uses dual monitors.