How to open multiple excel windows at the same time

By: Matthew Adams
2 minute read

For various PC problems, we recommend this tool.

This software will repair common computer errors, protect you from file loss, malware, hardware failure and optimize your PC for maximum performance. Fix PC issues now in 3 easy steps:

  1. Download this PC Repair Tool rated "Excellent" on TrustPilot.com.
  2. Click “Start Scan” to find Windows issues that could be causing PC problems.
  3. Click “Repair All” to fix all issues with Patended Technologies (requires upgrade).

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 new workbooks in multiple windows. When you select File > New > Blank workbook in Excel 2010, workbooks open in the same window. In addition, saved spreadsheets also open in the same Excel window. This is not ideal as you can’t compare spreadsheets in multiple windows. There are, however, a few workarounds that enable you to open multiple Excel windows at the same time.

Opening Multiple Windows from the Excel Jump List

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

excel

  • 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 Excel window, click File > Open to open a worksheet in it as shown below.

excel2

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

Open Multiple Excel Windows from the Start menu

  • Or you can open multiple Excel 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 Excel from the Start menu, a separate application window opens. As such, you can now open multiple spreadsheets in each separate window.

Open new Excel Windows with the Middle Mouse Button

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


For various PC problems, we recommend this tool.

This software will repair common computer errors, protect you from file loss, malware, hardware failure and optimize your PC for maximum performance. Fix PC issues now in 3 easy steps:

  1. Download this PC Repair Tool rated "Excellent" on TrustPilot.com.
  2. Click “Start Scan” to find Windows issues that could be causing PC problems.
  3. Click “Repair All” to fix all issues with Patended Technologies (requires upgrade).

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 multiple windows neatly on the left and right of the desktop.

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

excel3

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

excel4

  • 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.

excel5

So you can still open spreadsheets in multiple 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.

For various PC problems, we recommend this tool.

This software will repair common computer errors, protect you from file loss, malware, hardware failure and optimize your PC for maximum performance. Fix PC issues now in 3 easy steps:

  1. Download this PC Repair Tool rated "Excellent" on TrustPilot.com.
  2. Click “Start Scan” to find Windows issues that could be causing PC problems.
  3. Click “Repair All” to fix all issues with Patended Technologies (requires upgrade).

Discussions

Next up

Best Windows 10 antivirus software to use in 2018

By: Radu Tyrsina
7 minute read

Update – 2018 will soon come to an end and we already have a guide on what is the best antivirus you should get in […]

Continue Reading

These features are out for good with Windows 10 version 1809

iamsovy@gmail.com' By: Sovan Mandal
2 minute read

Microsoft is all set to launch its next big update, Windows 10 version 1809 in October. While that should be a nice piece of news […]

Continue Reading

Windows 10 18H2 builds no longer receive new features

By: Matthew Adams
3 minute read

The Windows 10 October 2018 Update (otherwise 18H2) rollout might now be two to three weeks away. For the last few months, new build previews […]

Continue Reading