Share this article
Improve this guide
How to Open Multiple Excel Files at Once in Windows 10 & 11
Newer Excel versions allow you to do this by default ✅
3 min. read
Updated onOctober 4, 2023
updated onOctober 4, 2023
Share this article
Improve this guide
Read our disclosure page to find out how can you help Windows Report sustain the editorial teamRead more
Key notes
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.
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 ofWindows 10Snap 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 appfrom the Start menu, a separate application opens.
-
Click on theStart buttonon your taskbar or press theWindows key. This will open the Start Menu.
-
Type Excel in the search bar orscroll to the folder that includes Excel on your Start menu.
-
Click on the app to open Excel from there.
-
Repeat step 2 to open another Excel window.
-
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.
More about the topics:Excel
Matthew Adams
Windows Hardware Expert
Matthew is a freelancer who has produced a variety of articles on various topics related to technology. His main focus is the Windows OS and all the things surrounding it.
He is passionate about the tech world, always staying up-to-date with the latest and greatest. With an analytical view, he likes problem-solving, focusing on errors and their causes.
In his free time, he likes to read and write about history and tries to always develop new skills.
User forum
0 messages
Sort by:LatestOldestMost Votes
Comment*
Name*
Email*
Commenting as.Not you?
Save information for future comments
Comment
Δ
Matthew Adams
Windows Hardware Expert
He is passionate about everything surrounding Microsoft’s OS, focusing on troubleshooting guides & tips for everyday problems.