Step 1: Open multiple instances of Excel 2010. How to open/view multiple Excel files in different windowsįirst, 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. If you don’t want to upgrade your Office, then do as follows. If you use Office 2016/2013, whenever you open a new workbook, automatically it will be displayed in a different window.Īccordingly, 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. The fact you should know is, in Office 2010 and earlier, all open Excel files share the same monitor.
Is there any way I can open Excel files in separate windows and view them side by side?”
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.