2 Monitors 2 Excel Sheets?

Question

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!

Update many years later... The View > New Window feature worked well for me: https://superuser.com/a/640247/74576 — Ryan, May 23 '20 at 21:50

score 29 · Accepted Answer · answered Nov 15 '13 at 16:27

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.

answered Nov 15 '13 at 16:27

panhandel

2,504
16
18

Thanks this worked, would you have time for http://superuser.com/questions/643401/super-slow-excel-how-can-i-increase-the-performance as well? – Anarkie Nov 15 '13 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 '13 at 16:58
Worked for me too. Upvoted. – Sudheer Kumar May 29 '19 at 07:21

score 3 · Answer 2 · answered Nov 15 '13 at 20:52

3

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

answered Nov 15 '13 at 20:52

guitarthrower

983
2
8
15

Thanks a lot! Would you have time for this http://superuser.com/questions/643401/super-slow-excel-how-can-i-increase-the-performance ? please... – Anarkie Nov 17 '13 at 00:33

score 2 · Answer 3 · answered Nov 15 '13 at 16:28

2

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

answered Nov 15 '13 at 16:28

Babblo

201
1
4

So essentially, exactly what @panhendel has said in his answer? – Nov 15 '13 at 18:25
1

Exactly! @panhendel was faster than me. :) – Babblo Nov 18 '13 at 12:18

2 Monitors 2 Excel Sheets?

3 Answers3

Linked