If you use Excel a lot and spend most of your day toggling across multiple Excel files, then having a dual monitor setup will help you tremendously! In fact, a New York Times study has shown that having an additional monitor increases productivity by 20 to 30 percent. However, the challenge is that some applications such as MS Office Excel load multiple files from the same instance of the application. This means that Excel opens multiple files on top of each other on the same monitor. And if you try moving one Excel file to the second monitor, all other Excel files also move to the second monitor.
How to display one Excel file on one monitor and another file on a second monitor
To display the two files side by side instead of on top of each other, you have to load the two files as two separate instances. To do this, you must open a new instance of Excel, then open/create a workbook. I’ve summarized the steps below.
- Open the first Excel file you need to access and put that on Monitor #1.
- Open a second instance of Excel on Monitor #2 by going to the Start Menu > Programs > Micrrosoft Office > Excel.
- Move this second instance of Excel to Monitor #2.
- Open or create a workbook from the second instance of Excel that’s now on Monitor #2.