How to Open/View Multiple Excel 2010 Files in Different Windows

view excel files side by side

“I’m using Excel 2010. Each time I open two or multiple Excel files, they are displayed in the same window, so I can’t view or compare the workbooks at the same time. Is there any way I can open Excel files in separate windows and view them side by side?”

The fact you should know is, in Office 2010 and earlier, all open Excel files share the same monitor. If you use Office 2016/2013, whenever you open a new workbook, automatically it will be displayed in a different window.

Accordingly, if you need to view multiple Excel 2010 workbooks at the same time in different windows, you can upgrade your Office to a newer version of Office. If you don’t want to upgrade your Office, then do as follows.

How to open/view multiple Excel files in different windows

First, you need to open multiple instances of Excel 2010, and then separately open the Excel files in different instances of Excel, so that you can view the workbooks in different monitors at the same time.

Step 1: Open multiple instances of Excel 2010.

There are three of four ways you can open a new instance of Excel, they apply in Windows 7/8/10. You can choose any of them depending on your own case.

Way 1: by clicking Excel icon on the taskbar

You can click the Excel icon appearing in the taskbar while pressing and holding the Shift key on your keyboard, to open a new instance of Excel.

excel icon

Alternatively, if you are using a mouse with a middle button or clickable scroll button, you can just put the mouse pointer on the Excel icon appearing in the taskbar and then click that mouse scroll button to open a new instance of Excel.

click mouse scroll button

Way 2: Using Run command

Open the Run dialog box using the Win + R keyboard shortcuts, then type excel into the box, and click OK. This will open a new instance of Excel.

type excel in Run box

Way 3: using Start menu

You can type excel in Start menu search box. When the ”Microsoft Excel 2010” appears in the search results, click on it so that a new instance of Excel 2010 should open.

Step 2: Open and view multiple Excel files in different Excel instances.

After you open a new instance of Excel 2010, navigate to the Excel file you want to open and then drag it into the new instance of Excel. In this way, you can open multiple workbooks in different instances of Excel so that you can view them in separate windows at the same time.

You May Also Like

About the Author: Darren


  1. Admiring the dedication you put into your blog and detailed information you present. It’s awesome to come across a blog every once in a while that isn’t the same outdated rehashed material. Great read! I’ve bookmarked your site and I’m adding your RSS feeds to my Google account.|

  2. I like the helpful information you supply for your articles. I’ll bookmark your weblog and test once more here frequently. I am reasonably sure I’ll be informed a lot of new stuff right here! Good luck for the next!|

  3. An impressive share! I’ve just forwarded this onto a co-worker who had been conducting a little research on this. And he actually ordered me dinner due to the fact that I found it for him… lol. So let me reword this…. Thanks for the meal!! But yeah, thanks for spending some time to discuss this topic here on your web site.|

  4. Great post. I used to be checking constantly this weblog and I am impressed! Very helpful information specifically the final phase 🙂 I handle such information a lot. I used to be looking for this certain information for a long time. Thank you and best of luck. |

  5. I am now not positive where you’re getting your information, but great topic. I needs to spend a while studying much more or working out more. Thanks for excellent info I used to be searching for this info for my mission.|

  6. I must thank you for the efforts you have put in penning this blog. I’m hoping to check out the same high-grade blog posts by you later on as well. In fact, your creative writing abilities has motivated me to get my own, personal website now ;)|

Leave a Reply

Your email address will not be published.