Two worksheets on two different monitors

[test_man2]

Greetings! Is there a way to open the same spreadsheet (on the same computer) twice so that one can view two different worksheets at the same time? I'd like to reference worksheet1 while building a formula in worksheet2 without having to flip back and forth. Right now, the only way I can think of doing that is to make a copy of the spreadsheet, perhaps name it name_ref1, and then open both spreadsheets. Is there a way to open just one spreadsheet instead?

 

[test_man2]

Not sure if this works with different monitors, but if you go to the View tab & select New Window, you can look at two different sheets at the same time.

Beautiful! Thanks, Fluff!
And I just verified that it does work across different monitors. I selected New Window and then moved that one over to my other monitor.

 

[test_man2]

There is a registry entry that you can create so that Excel opens a new instance with every workbook. I use it on all of my computers. There are a few variations of the entry that I've seen, but give this one a try.

Edit the Registry​

• First, close all instances of Excel.
• Open the Registry Editor.
• Go to HKEY_CURRENT_USER\Software\Microsoft\Office\16.0\Excel\Options.
• Click Edit in the menu, press New, and select DWORD value.
• Name the entry ‘DisableMergeInstance’, press enter.
• Right-click the entry DisableMergeInstance, and select Modify.
• In the Value data box, fill in 1, and click OK.

Thanks for the suggestion, Candyman, but I'm on a work computer and therefore can't edit the registry.

 

[Joe4]

I cannot open the same file in two windows...but every different file I open is in it's own instance of Excel.

I think that is precisely what the OP was asking for, was it not?

Is there a way to open the same spreadsheet (on the same computer) twice so that one can view two different worksheets at the same time?

So it appears then that the Registry solution would not help in this case.

 

[Fluff]

Glad we could help & thanks for the feedback.