When you select File > New > Blank workbook in Excel 2010, worksheets open in the same window. In addition, saved spreadsheets also open in the same window. This is not ideal as you can’t compare spreadsheets in two or more windows.

How to open multiple Excel windows at the same time?

There are a few workarounds that enable you to open multiple Excel windows at the same time and we will present all of them to you, in order.

1. Use Excel’s Jump List

2. With the Middle Mouse Button

If you have a mouse with a middle button or scroll wheel, you can open multiple windows with that. Open Excel and then select its taskbar icon with the middle mouse button. That will open a new window for you to open a spreadsheet.

3. With Snap Assist

Now you can open Excel spreadsheets in multiple windows at the same time, you can make the most of Windows 10 Snap Assist. Snap Assist enables you to open two or more windows neatly on the left and right of the desktop.

4. Through the Start menu

If you are using an older version of Excel and are looking for a way to open multiple files at the same time in different windows, you can do this through the Start menu. Each time you open the Excel app from the Start menu, a separate application opens.

  1. Click on the Start button on your taskbar or press the Windows key. This will open the Start Menu.

  2. Type Excel in the search bar or scroll to the folder that includes Excel on your Start menu.

  3. Click on the app to open Excel from there.

  4. Repeat step 2 to open another Excel window.

  5. Create as many windows as you want. Every time you start Excel from the Start menu, a new window will be created. As such, you can now open multiple spreadsheets in separate windows.

So you can still open spreadsheets in two or more windows with earlier versions of Excel. The separate windows are better for comparing and analyzing alternative spreadsheets and copying numerical values from one sheet to another. We hope that you managed to open multiple files at once in Excel using our guide. Let us know your thoughts in the comments section below.

Name * Email * Commenting as . Not you? Save information for future comments
Comment

Δ