How Can I Open Two Excel Books at the Same Time?

By Sonia Waring

Most applications allow you to open two documents and view them side by side because they open in two separate windows of the same program. Not so with a handful of apps, including Microsoft Excel. Although you can have two or more Excel workbooks open at once, and see all of them separately in the Windows task bar, when you switch between books, you'll see that each file occupies the same window, making it seem impossible to see both at the same time. Fortunately, a workaround exists.

Step 1

Open one Excel file in Excel.

Step 2

Click the "Start" orb and type "excel."

Step 3

Click "Microsoft Office Excel" when it appears in the Start menu to open the program.

Step 4

Open the second Excel workbook by clicking the "Office" button in Excel, choosing "Open" and navigating to the file.

Tips & Warnings

  • Open Excel from its program icon for each separate Excel window that you want; if you double-click on an Excel workbook in Windows Explorer, it will open in the existing Excel window.
  • You can also view multiple workbooks in the same window by choosing "View," "Arrange All" and selecting from options including "Tiled" and "Cascading."