
How to Open Two Windows for the Same Excel File (and Same Sheet) Side by Side
Read More: Excel Files Not Opening in Separate Windows (4 Solutions) Then drag manually and place the Excel windows in the desired positions. You can also open two workbooks and place them side by side with the Restore Down button in the top-right corner. Open Two Excel Files and Place Them Manually Side by Side Choose from the options according to your need.
The following pop-up window will appear. Then go to the View tab and click on the Arrange All button from the Window group.
Use the ‘Arrange All’ Button from the View Ribbon
Then press the Win+ ← (Wind + Left Arrow keys) to place it on the left side of the monitor.Ģ. Click on it and press the Win+ → (Wind + Right Arrow keys) to place it on the right side of the monitor. If you are a Windows 10 (or higher) user, you can open (we have already discussed how to open multiple Excel files) and place two Excel workbooks using Win + Arrow keys. Use Win and Arrow Keys for Windows 10 or Higher Versions Now, if you want to work with two Excel files at the same time, you will find it useful if both of them are present in front of you. Read More: Unable to Open Multiple Excel Files (8 Reasons with Solutions)ģ Easy Ways to Open Two Excel Files Side by Side If you use any of these versions, whenever you want, you can open two or more Excel files the way you opened the first Excel file. Now, whenever you need to open a new Excel file, double-click on the shortcut, and open a new file with the File tab > Open button > Browse sequence.įor Excel 2013 | 2016 | 2019 | 365 Users: Then right-click on the EXCEL or EXCEL.EXE icon and click on Create shortcut option from the context menu.Ī desktop shortcut will be created this way. Go to the search bar of your Windows and type excel.exe, then right-click on the icon and click on the Open file location button. You can also open the second Excel file in any known way. Then do the same as in the first technique. Hold it and click on the Excel icon in your taskbar. Then go to the File tab, click on the Open button, and then browse your second file. 👉 Right-click on the Excel icon in the taskbar and open a new MS Excel window. Then open the second Excel file in one of the following ways. First of all, you open the first Excel file normally. If you are a user of Excel 2010 or earlier versions, you can open multiple Excel files in one of the following ways. So all workbooks are opened in the same application window and have a shared ribbon user interface (toolbar in Excel 2003 and older). In these versions, multiple windows are nested under the main window with this interface, but only the head window has a toolbar/menu bar. The Multiple Document Interface is present in Excel 2010 and older versions (MDI). Related Articles How to Open Two Excel Files Simultaneously