Saturday, September 21, 2013

[Guide] Opening two excel workbooks in two different windows

Looks like it cannot get any more trivial than this. Wouldn't just double clicking two workbooks (xls, xls files) work? Apparently, with all their wisdom, Microsoft have decided that people don't wanna see multiple Excel sheets. By default, all the workbooks will open in the same Window. This is applicable to Office  2007, 2010 and 2013 all it seems. 

But especially when you have multiple monitors, you want to load them up in separate displays to make use of all the screen real estate you have. An ugly way of doing that is resizing the Excel window to span across both displays (you cannot Maximize it though) and then vertically splitting the workbooks so that one stays on the left hand side display and the other stays on then right hand side display. 

But there is a better way to do it. 
  • First, open one of the workbooks by double clicking the file. An Excel windows will be launched and the file will be opened in it.
  • Now, you should see the Excel window on the Taskbar. Right click on it and click "Microsoft Excel". That will open up a new window. 
  • Now all you have to do it to either drag and drop the other workbook on to this new window or open that workbook via File -> Open. 


That's it. Now you have the workbooks opened up in separate windows. You can extend the same method to open up many excel files in separate windows.
Related Posts Plugin for WordPress, Blogger...