Reader Question: Open Excel on Multiple Monitors
Question:
Tony,
Thanks for your help setting up multiple monitors. I have been experiencing  one problem and wonder if you know the solution: are we able to open different excel windows in both monitors, ie spreadsheet 1 on monitor 1 and spreadsheet 2 on monitor 2? I have this flexibility in Word.
Thanks for your help.
Alok
Answer:
Yeah, this bugs me, too. If you open two Word documents, you get two windows. If you open two Excel documents, you get ONE window! Why can’t they be consistent within Office? It’s always been this way, even in Office 2007. Office 2007 will even show different taskbar buttons, but they both control a single window.
Anyway, here’s an easy work-around: resize the Excel window so that it covers both your monitors. If you use Ultramon, just right-click the taskbar, and then click Maximize to Desktop.
Then, tile the windows in Excel. In Excel 2007, click View, and then click View Side By Side. In earlier versions of Office, click the Window menu, and then click Tile Vertically (or whatever the command is).
Posted: March 24th, 2007 under Office 2007, Reader Questions.
Comments: 4
Comments
Comment from Knox
Time: March 24, 2007, 10:15 pm
What you may want to do is launch a true second copy of excel. You do this by selecting excel off the start menu (or the orb menu for vista) and hold down on the control key just as you click on the excel shortcut. I generally drag my document into that excel window to control that the document opens in the correct 2nd copy. The one disadvantage of this method is that copy and paste works only as text in that mode.
Comment from Goldberg
Time: April 8, 2007, 10:31 pm
Open up excel from the run command. i.e. Go to Start >> Run.
Then type in excel and select enter. Do this agian for the second window of excell.
Comment from cgarison
Time: May 25, 2007, 8:24 pm
As long as I launch MS Excel from the “Start Menu” I can have as many different instances of the program that I want. I can have a copy of Excel 2007 running in each of my displays or I can have 4 Excel applications tiled in my single 24″ display and an additional 4 in my 22″ display. It is just a matter of launching Excel as many times as I need it from the start menu.
Comment from Donald
Time: June 4, 2007, 1:36 am
Using Excel 2007, you can correct the paste limitation by using the ‘Paste Special’ command and selecting XML Spreadsheet option.
I haven’t tried this in earlier versions but formulas, borders and text formattng seem to work ok.
Write a comment