How to Open 2 Excel Spreadsheets on Dual Screens

By Filonia LeChat

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 1

Open Microsoft Excel and click the "File" tab.

Step 2

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

Step 3

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 4

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.

Tips & Warnings

  • If both Excel spreadsheets are not in the same folder or location, browse to each separately and double-click their file name to open them. They'll open on the same screen. After both have opened, drag one onto the other monitor.