Secondly, if you copy formulas from one instance of Excel, you can only paste their values into the other instance, and not the formulas themselves. Firstly, you can’t write formulas that link between the two instances. You can open the second document from there.īe aware that running two instances of Excel does have some drawbacks. Be sure your Mac meets the system requirements and note that the steps below are for Office 2016 and Office 365. This will create a second copy of Excel which you can display on the secondary screen. First you’d need to delete the existing Office on your Mac by opening the Application folder and deleting the suite. Then, instead of opening the second file from within Excel, go to the Start menu and open Excel from there again. To do this, open Excel and open your first file as normal. However, you can run two instances of Excel to get this to work.

Or you could have an original document shown on one and a marked up version on the other.Įxcel itself won’t let you split it across two screens as a default – it will always display itself all on one screen or the other. emails and administrative work on one screen principle work on the other.

Generally, it’s easiest to work with two screens if you have a defined purpose for each: e.g. For my day job, I run 64-bit Windows Excel 2016 on a late 2016 MacBook Pro in a Windows 10 virtual machine using Parallels.