How Do I View Two Excel Spreadsheets on My Two Monitors?
A computer setup with dual monitors can vastly improve job efficiency if you need to access data from one product and transfer it to another. Rather than spend an enormous amount of time shifting back and forth between software products, you can place one set of software on one monitor for data gathering and the software product you need to transfer the data to on the second monitor. If you need to access data in one Excel spreadsheet and place some of it in another Excel spreadsheet, you will save time by using the dual monitor setup.
Open Excel and access the file you want to retrieve the data from.
Place the open Excel file on the monitor of your choice.
Open the Excel program again from your desktop or the Start menu and drag the newly opened version of Excel to the monitor not currently taken.
Access the Excel file you wish to enter data into in the newly opened copy of Excel.
Tips & Warnings
- You must open a new copy of Excel in order to use the dual-monitor feature. If you open the two files in the one working copy of Excel, you cannot drag and drop one file onto another monitor as you can in MS Word.