How do I open a second instance of Excel?
Table of Contents
How do I open a second instance of Excel?
As the menu appears, hold down the ALT key and left-click on the ‘Excel’ menu option. Continue to hold down the ALT key until the below window pops up. Press ‘Yes’ to open a new instance. In fact, you can also hold down the ALT key, hover your mouse over the Excel icon in the taskbar and click your scroll-button.
Why do two instances of Excel open?
Believe it or not, this problem is actually a feature of Excel. What you are seeing is two windows, both open on the same workbook. Excel allows you to create multiple windows on the same workbook by using the Window | New Window.
Can you have two Excel sheets open at once?
If the worksheets that you want to view are in the same workbook, do the following: Click a worksheet that you want to view. On the View tab, in the Window group, click New Window. Repeat steps 1 and 2 for each sheet that you want to view.
How do I open two Excel files side by side vertically?
You can also arrange those windows to appear side-by-side. In the ribbon, click View > Arrange All > Vertical > OK. The two workbooks will now appear in the same window, as shown below.
Why can’t I open 2 Excel files at the same time?
The error Sorry, Excel can’t open two workbooks with the same name an occur when you try to refresh a workbook containing Quick reports and or Time series. This error can also occur when launching Microsoft Excel with a blank page. This error usually occurs if there a conflict between 2 versions of the Excel add-in.
Why won’t Excel let me open two windows?
The solution is to change how you are starting Excel. Instead of double-clicking on one of the workbooks in the selection set, right-click on one of the files and choose Open. The selection set remains intact and all the files are opened in Excel, as desired.
How do I open two Excel spreadsheets with the same name?
Assuming you already have the file open and you decide you want to look at a previous version, go to File > Open, then instead of hitting Open use the Open drop down box and select “Open as Copy”. It will open a copy of the file and Prefix it with Copy(1), it will also create a copy in the folder with that name.
Why can I not open two Excel windows?
Press the Shift Key Alternatively, you can open multiple Excel windows by pressing and holding the Shift key. First, open the Excel software. Then hold the Shift key, and click Excel’s taskbar icon. That will open another window for the application that users can drag to both desktop sides as outlined above.
How do I separate two Excel Windows?
Split a sheet into panes
- Select below the row where you want the split, or the column to the right of where you want the split.
- On the View tab, in the Window group, click Split. To remove the split panes, click Split again.
