How do I open two Excel workbooks in separate windows?

View two worksheets in the same workbook side by side

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

Why can’t I have 2 Excel windows open at the same time?

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 I save multiple Excel tabs as separate files?

Step 1: Select the worksheet names in tab bar. You can select multiple with holding down Ctrl key or shift key. Step 2: Right click the worksheet name, and click the Move or Copy from context menu. Step 3: In Move or Copy dialog box, select the (new book) item from the drop down list of Move selected sheets to book.

Why does Excel open in the same window?

My Problem: Microsoft Excel opens each new worksheet in the same window. I want each new file to open in a new Excel program window, so that each new worksheet excel does not open in the same window. Solution: To fix this, you need to tell Excel that you want each new window to open separately from your old file.

How do I open Excel 2010 files in separate windows?

If you want to open workbooks in separate application windows, you will have to start multiple instances of Excel:

  1. Start Excel and open a workbook.
  2. Right-click the Excel icon in the Windows taskbar and select Microsoft Excel 2010 from the context menu.
  3. A new instance of Excel will start in a separate window.

How do I open multiple Excel files at once?

Opening Multiple Workbooks at Once

  1. Choose Open from the File menu.
  2. Instead of double-clicking on a file name, start to create a “selection set.” If you are selecting sequential files, click on the first file in the sequence, then hold the Shift key as you click on the last.

How do I split an Excel spreadsheet into multiple files based on columns?

How to split Excel sheet into multiple worksheets

  1. On Step 1 choose your range.
  2. On Step 2 select one or more key columns for splitting.
  3. On Step 3 choose destination for the resulting split tables.
  4. On Step 4 select additional options: worksheets names, header and formatting.

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.

How do I make Excel open 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 .