How to Open 2 Excel Spreadsheets on Dual Screens

One Excel spreadsheet may appear overwhelming with its long screen of seemingly endless cell boxes, but opening two Excel spreadsheets at one time may actually reduce your workload and allow you to work more efficiently. The Microsoft Excel software permits opening multiple instances of the program at once. Working on dual monitors means being able to cut, copy, paste or just review data from two spreadsheets without having to toggle between the two or constantly send one spreadsheet to the bottom of your work screen.

Step

Open Microsoft Excel and click the “File” tab.

Step

Click “Open” and browse to the location of the two spreadsheets to open.

Step

Press and hold down the “Ctrl” key. Click once on each spreadsheet file name. Click the “Open” button. The two spreadsheets open, but on the same monitor.

Step

Click the title bar stretching across the top of the Excel worksheet – it may say “Book1 – Microsoft Excel” or the title you gave the spreadsheet. Drag the screen onto the other monitor and drop it, then click the “Maximize” button in the top-right corner of the screen to lock the spreadsheet into place on the second monitor.