How To Get Excel Spreadsheets To Open In Separate Windows

Remove From My Forums

How to Open Two Excel Files in Multiple Monitors in Windows 7

Question
How to open two excel files in 2 excel windows using multiple monitors in Windows 7.
Currently it opens multiple files on top of each other on the same i monitor.

I found this article in a blog information technology says

"The snap characteristic that y'all are looking for will not piece of work unless you open up 2 instances of Excel. This is because Excel Dissimilar Give-and-take is not a Truthful SDI Application. Microsoft is aware of the Issue all the same there is no resolution to the trouble but the workaround"
- Moved by Tuesday, March thirteen, 2012 9:03 PM moving to a more than appropriate forum (From:Windows seven Installation, Setup, and Deployment)

Answers

I only did a exam on my multiple screens, it worked. To practise this, s imply open Excel by double clicking the icon on your desktop and open the outset Excel file you want to use. Minimize this window and movement it to the right screen. Then go back to the desktop, double click the Excel icon once again, another separate Excel window volition open up. Open up the second Excel file from within the split up window and move it to the left screen. You can open up as many files and split up windows as yous need using this method.

If you exercise not take an Excel shortcut on your desktop but would like one, find Excel in the Programs listing. Right click it, betoken to Ship To and so click Desktop. A shortcut will be placed on the desktop.

Excel 2007 provides a simple solution for users who want to open up all Excel files in separate windows. To access this setting, open Microsoft Excel. Click the Office Button and then click Excel Options, which is down at the bottom right side of the bill of fare. Select Advanced, which is on the left, then scroll downwards to Brandish. Select the Show All Windows in Taskbar checkbox and so click OK.

Best Regards
Dale
- Proposed equally reply by Dale Qiao Friday, March 12, 2010 half dozen:01 AM
- Marked every bit answer by Dale Qiao Sunday, March fourteen, 2010 1:47 AM
Don't know if i get you're question right. Simply i'll give it a shot.

I presume yous defined the two monitors every bit an extended desktop. You lot tin can start excel for the first time and open a canvass and motility the window to the first screen. Adjacent you offset another instance of excel open up the worksheet and move information technology to the correct sheet (you tin can only move a sheet to another monitor when it'southward size is not on "full screen".

The alternative fashion is open two excel sheets in one excel case. Next you choose the tab "View" and click the "all window" option, then you can select that all the open windows should appear next to eachother. When you brand your Excel instance a large as yous're desktop (across ii screens) y'all tin run into both of the excel sheets in one instance.

Works on office 2007, haven't tried in on 2003 merely i assume it is possible.

Goodluck !
- Proposed as answer by Dale Qiao Friday, March 12, 2010 5:57 AM
- Marked as respond by Dale Qiao Lord's day, March 14, 2010 1:47 AM

Source: https://social.technet.microsoft.com/Forums/en-US/6ba32569-19a0-4b45-806f-9a42258bdb5f/how-to-open-two-excel-files-in-multiple-monitors-in-windows-7

Posted by: luftacte1966.blogspot.com