Excel 2007 open workbooks in separate windows

Show all Excel windows in taskbar with Excel Options. Show all Excel windows in taskbar with Office tab. In Excel and , you need to check an option in the Excel Options to solve this task.

Then click OK to close this dialog, and all the opened workbooks have been displayed in the taskbar, you can switch among them quickly, see screenshots:. Note : In Excel , this Show all windows in the taskbar feature has been removed from the Excel Options. If you have installed Office Tab in your computer, it helps you view and edit multiple files within a single tabbed window, to know more about Office Tab and want to down load it please click here.

After installing Office Tab , open multiple workbooks, you will see all the workbooks name have been displayed within a single tabbed window as following screenshot shown:. Note: The other languages of the website are Google-translated. Back to English. 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. If you want to have a free trial of this utility, please go to Click for free trial of Office Tab first, and then go to apply the operation according above steps. Note: The other languages of the website are Google-translated.

Back to English. Log in. Remember Me Forgot your password? Password Reset. Maybe its because Windows 7 is too new, maybe its because the option has been removed. Opening each document in a separate instance of Excel really uses a lot of memory. I must ask you why you want to do this by default?

What are you trying to accomplish. I want to work between several spreadsheets at a time. It's the only way I know to easily be able to have more than 1 sheet open on the desktop, copy data from 1 and paste to another directly by highlighting the specific sheet I require with the mouse. Otherwise I have to muck around using the mouse to highlight tabs, or opening the grouped items on the taskbar and then decide what sheet is applicable. With 8GB ram I'm not worried with the amount of memory used with several spreadsheets in use at the one time.

More than anything else; I want to be able to use a spreadsheet, click the office, thenn new buttons and have another new sheet open in addition to the page that I am already using, rather than "usurping" the page that I was previously using.

How about: Open multiple workbooks in one instance of Excel. Then choose View, Arrange All, Tile. You can also arrange a number of other ways depending on what works best for you. See how that works for you and get back to us because someone may have the multiple instances issue solved. If you are lucky enough to have dual monitors you can restore Excel down and then manually drag it so that it occupies both monitors.

Then use the steps above will be very nice. I just tried option 1 Shane suggested on my Win 7 machine and it appears to work as advertised. Any Excel file I open from that folder nicely opens in its own instance. I expect if you click the View tab of that dialog and click the apply to folders button all folders will work that way.

But I cannot determine how to alter this setiing with O2K7. I am also using Windows 7 Ultimate. Really appredciate a solution After installing that add-on, Excel will include alternative tabs for separate spreadsheets.

Then users can right-click a spreadsheet tab and select its Open in New Window context menu option. So, there are a few ways users can open Excel spreadsheets in separate windows. Commenting as. Not you? Save information for future comments. Microsoft introduces a new collaboration tool for Office, called Loop.