How do I get Excel 2010 to open in separate windows?

Table of Contents

Right-click the Excel icon on the taskbar and pick Microsoft Excel 2010 or Microsoft Excel 2007. Then navigate to File> Open and browse for your second workbook. Press and hold the Shift key on your keyboard and click the Excel icon on the taskbar. Then open your second file from the new instance.

How do you 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.

How do I open two Excel spreadsheets in separate windows?

Q. How can I view two different Excel sheets side by side?

On the View tab, in the Window group, click View Side by Side .
In the workbook window, click the worksheets that you want to compare.
To scroll both worksheets at the same time, click Synchronous Scrolling in the Window group on the View tab.

How do you open a separate instance of Excel?

Right click on the Excel icon in the taskbar. 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.

How do you open an Excel file in a new window?

To make a new window, go to the View tab on the Ribbon and press the New Window button. This will create a new window of the active workbook (the workbook you were viewing when you pressed New Window). The keyboard shortcut to open a new window is Alt + W + N .

How do I open two Excel files side by side in windows 10?

View two worksheets in the same workbook side by side

On the View tab, in the Window group, click New Window.
On the View tab, in the Window group, click View Side by Side .
In each workbook window, click the sheet that you want to compare.
To scroll both worksheets at the same time, click Synchronous Scrolling.

Why do Excel 2010 files not open in separate windows?

If you want to open workbooks in separate application windows, you will have to start multiple instances of Excel: Start Excel and open a workbook. Right-click the Excel icon in the Windows taskbar and select Microsoft Excel 2010 from the context menu. A new instance of Excel will start in a separate window.