23

I have 2 Monitors and want to observe on one monitor 1st sheet and on the other monitor 2nd sheet but no matter how many excel files I open they are all on one monitor.

Can I split them to two screens?

I have Excel 2007 and working on 2003 file. Thanks a lot for your time!

1

3 Answers 3

29

The only way I have been able to accomplish this is to open a brand new instance of Excel (either from the start menu, task bar via right click in Win7/Vista, etc) and open the second file from that new Excel window.

If you continually use the same excel window to File -> Open new files, it will keep the documents all grouped into the same instance and move every file to the same monitor like you're experiencing.

3
  • Thanks this worked, would you have time for superuser.com/questions/643401/… as well?
    – Anarkie
    Nov 15, 2013 at 16:38
  • I don't know of a fix for that other thing off the top of my head, but I'll research when I can.
    – panhandel
    Nov 15, 2013 at 16:58
  • Worked for me too. Upvoted. May 29, 2019 at 7:21
3

You can also spread the Main excel file across both screens and then use View > Arrange Windows > Tile Vertically.

1
2

You need to open 2 instances of Excel, move each one to a monitor and then open the files.

2
  • So essentially, exactly what @panhendel has said in his answer?
    – user201262
    Nov 15, 2013 at 18:25
  • 1
    Exactly! @panhendel was faster than me. :)
    – Babblo
    Nov 18, 2013 at 12:18

Not the answer you're looking for? Browse other questions tagged .