How To Open Two Excel Windows Side By Side?

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

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

Contents

How do I open two separate 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 open two Excel files in separate windows 2016?

Open Multiple Workbooks in the Same Window

  1. If the Excel Application is already opened, we can use the Open command from the File Menu and select multiple Excel Workbooks to Open in the Same Window.
  2. If the Excel Application is already opened, we can drag the workbooks and drop in already opened Excel Application Window.

Why can’t I open 2 Excel files 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 I get Excel to show horizontally side by side?

First, open two or more workbooks.

  1. Select the desired arrange setting. For example, click Horizontal.
  2. Click OK.
  3. On the View tab, in the Window group, click View Side by Side (by default, Synchronous Scrolling is activated), to scroll both workbooks at the same time.

How do I open multiple Excel files at once?

To do this, follow these steps: Choose Open from the File menu. Excel displays the Open dialog box. 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 open two separate Excel 2010 files?

  1. Open your first Excel file and place it on the screen you want.
  2. Open a new Excel file from the Excel icon.
  3. The new file will open on top of the one you have already opened. Drag it to the other screen.
  4. Drag the icon for the second Excel file INTO the new (blank) Excel document.

How do I open two Excel 2010 documents side by side?

How to View Excel 2010 Spreadsheets Side-by-Side for Comparison

  1. Open the first Excel spreadsheet.
  2. Open the second Excel spreadsheet. You’ll notice that there are now two taskbar buttons for Excel.
  3. In Excel, Click the View tab.
  4. In the Window section, Click View Side by Side.
  5. To change the orientation, Click Arrange All.

How do I make Excel side by side vertically?

You can work in either or both windows and the workbook will be updated. 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.

How do I open two instances of Excel?

Right click on the Excel icon in the dock, a menu appears, hold down the Alt key and left click on the Excel icon. Keep holding the Alt key until the following window appears. Click Yes to open a new instance.

How do I open 2 Excel windows in 2019?

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.