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.
Open Microsoft Excel and click the "File" tab.
Click "Open" and browse to the location of the two spreadsheets to open.
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.
Video of the Day
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.