4 ways to open Excel worksheets in separate windows at the same time

3 minute read
open Excel worksheets in separate windows at the same time

Home » How To » 4 ways to open Excel worksheets in separate windows at the same time

Microsoft Excel is undoubtedly one of the best spreadsheet applications for Windows. However, in earlier versions of Excel up to 2010 you can’t automatically open multiple Excel windows.

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.

There are, however, a few workarounds that enable you to open multiple Excel windows at the same time.

Open multiple Excel windows at the same time: full guide

  1. Opening Multiple Windows from the Excel Jump List
  2. Open Multiple Excel Windows from the Start menu
  3. Open new Excel Windows with the Middle Mouse Button
  4. Get Snapping!

Method 1 – Open from the Excel Jump List

  • First, you can open multiple windows from the software’s Jump List in Windows 10. To do so, open Excel and right-click its taskbar icon as below.


  • The Jump List includes a Microsoft Excel option on it. In the example above, it’s Microsoft Excel 2010 Starter.
  • Click Microsoft Excel to open a new, separate Excel spreadsheet window.
  • Now you have opened a second window, click File > Open to open a worksheet in it as shown below.


  • Alternatively, you can also hold the Shift key and left-click the taskbar icon to open multiple spreadsheet windows.

Method 2 – Open from the Start menu

  • Or you can open multiple spreadsheet windows from the Start menu. Click the Start button to open that menu.
  • Then scroll to the folder that includes Excel on your Start menu.


  • Select to open Excel from there.
  • Each time you open it from the Start menu, a separate application opens. As such, you can now open multiple spreadsheets in each separate window.

Method 3 – Open new Excel Windows with the Middle Mouse Button

If you have a mouse with 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 in.

Method 4 – Get Snapping!

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.

  • Select one spreadsheet window and click its Restore Down button.
  • Then move it to the far right or left side of desktop. That snaps the window to one-half of the desktop as shown below.


  • Next, select one of the spreadsheet thumbnails to open another window on the other side of the desktop as in the snapshot below.


  • Or you could drag a spreadsheet window to the top left, right or bottom corners of the desktop to arrange up to four spreadsheets as below.


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.


Editor’s Note: This post was originally published in October 2016 and has been since updated for freshness, and accuracy.


Next up

WerFault.exe error on Windows 10: Here are 4 quick solutions

Vladimir Popescu avatar. By: Vladimir Popescu
3 minute read

The WerFault.exe error on Windows 10 is more common than you might think. If you’re seeing this error message, you are not the only one. […]

Continue Reading

FIX: Twitch error deleting video

Aleksandar Ognjanovic By: Aleksandar Ognjanovic
2 minute read

Twitch is the leading platform when it comes to streaming games (or any other) live content these days. The usage is seamless and intuitive on […]

Continue Reading

Top 5 software for Parametric Image Editing for pro photographers

Tashreef Shareef avatar. By: Tashreef Shareef
Less than a 1 minute read

Parametric Image Editing is the process of making changes to an image while preserving the original image. All the changes made to the images are […]

Continue Reading