Open excel in separate windows office 2010

Thankfully in Office and each time you open a new file it is automatically displayed in a new window. If your computer can be connected to another screen you can easily extend your display so that you can drag windows from one screen on to another.

With screens being relatively cheap this is a fantastic way to double the size of your Desktop! Right-click the Desktop of your computer and select Screen Resolution from the shortcut menu. From the Display options select the screen that will display the presentation. From the Multiple displays option select Extend these displays. You can now drag a window on to the additional screen. To do this first resize the window so that it is a floating window, i.

Note: Windows will default back to the normal primary monitor as soon as you disconnect from the additional monitor. Was this blog helpful?

Let us know in the Comments below. If you enjoyed this post check out the related posts below. Excel Essential Skills. Excel Organise, Analyse Data. So basically, she can't split them between her two monitors anymore. I can do a side-by-side view of the two files or resize them and stack them on top of each other within that window, but she doesn't like that option because she can't really take advantage of her dual monitors that way not to mention the two files are a lot smaller if she looks at them in that view.

I have found that it's possible for her to just open the Excel File 1 by double clicking it as she has been, then opening Excel. Which works and has the two files in different windows, but she doesn't see that as an acceptable workaround and gives me the "But I never had to do that before! When I do that, she can't even open the spreadsheets at all and gets "There was a problem sending the command to the program" upon trying.

Is there anything else I can do with this? Everything I've read on this issue says Excel doesn't support running multiple instances like that, and that we shouldn't have been able to do it in the first place, and that upgrading to or higher would fix it. I can try to explain more clearly what exactly we're trying to do here if needed, but I hope that all makes sense. Any windows or Microsoft updates applied in the last few days?

Also, are all of the Microsoft office service packs applied for office ? Until you figure it out, you can type "excel" in the run prompt and it will open a new instance. Then, use ctrl-o to open the file. I don't know how it was working for her until just recently, since that has never been a behavior of Excel for as long as I can remember. The problem is because Excel uses DDE functions differently than Word, which did have the ability through a poorly documented registry hack.

This is a well documented complaint going back to that Excel will not open a new window when double clicking on a file directly - and that is the intended function. Only recently Excel have changed I could clearly remember only very recently I was able to open a few Excel files on my lappy and it opened using different sessions and not different tabs since a long time ago I just tried on my Win10 just now and its diff instances. Maybe try something like Windows taskbar not combining icons not combine even when taskbar is full?

Or like click one excel then shift click another file this seems to be a bug as it forces the settings for some cases. Yeah, the interesting thing is that throughout most of the Google searching I've done on this, I've seen "that's not supposed to work in Excel " as the general answer. Office Tab helps to open multiple Excel files in a single tabbed window. You can open a specified workbook in a new window with its Open in New Window function as below demo shown.

Download Office Tab now! Besides the above method, you can open Excel workbooks in new windows with Start menu. Please do as follows. Click the Start button to show the menu. See screenshot:. The last method for opening Excel workbooks in new window is to create a shortcut. Then an Excel shortcut is placed on the desktop.

Double click it, and a new Excel window will be opened. If you need to open multiple workbooks in new windows, you should repeat step 4 to open them one by one. In this section, I will show you a handy applications — Office Tab. After installing Office Tab , open the workbooks you want.

Then you will see all workbooks are opened in an Excel window as tabbed browsing status. If you want to open a specific workbook in a new window, please right click this workbook tab, and then click Open In New Window in the list.