How to View Two Sheets Side by Side in Excel

HomeExcel BasicsHow to View Two Sheets Side by Side in Excel

Excel has a feature to split and compare two worksheets of the same or different workbooks and with the help of which users can compare the data of those sheets quickly without switching between them again and again.

Users can also sync scrolling between those worksheets which makes comparison very quick and easy.

We have mentioned some quick and easy steps for you on how to split the two or more worksheets of the same or different workbooks.

Split and View Two Sheets Side by Side of the Same Workbook

  1. First, go to the “View” tab and click on the “New Window” icon under the “Window” group on the ribbon.
    1-new-window-icon
  2. The number of times you click on “New Window”, you will get the copies of the currently opened workbook.
  3. Excel auto adds the numbers like 1, 2,3, and so on at the end of the name of the copied workbooks.
    2-copied-workbook
  4. After that, click on the “Arrange All” icon under the “Window” group on the ribbon.
  5. Now, select the split-screen view (Tiled, Horizontal, Vertical, Cascade) from the drop-down and click OK.
  6. The “Windows of active workbook” option should always be tick marked while splitting the sheets of the same workbook.
    3-arrange-all-icon
  7. At this point, your current workbook gets split into two parts.
  8. To switch the sheets between these two, just click on the sheet tab, you want to display for comparison.
    4-worksheets-split

Note: Users can split more than two workbooks at the same time just by creating more copies of the workbook from the “New Window” icon under the “Window” group on the ribbon.

Split and View Two Sheets Side by Side of the Different Workbooks

  1. First, open the workbooks, you want to split and compare.
  2. After that, go to the “View” tab and then click on the “Arrange All” icon under the “Window” group on the ribbon.
  3. Now, select the split-screen view (Tiled, Horizontal, Vertical, Cascade) from the drop-down.
  4. In the end, uncheck the “Windows of active workbook” option and click OK.
    5-arrange-all-dropdown
  5. At this point, your opened workbooks get split into two parts.

Synchronous Scrolling between the Sheets of the Same or Different Workbooks

The Synchronous Scrolling feature allows users to scroll the worksheets between two workbooks at the same time using split-screen views.

  1. First, go to the “View” tab and click on the “View Side by Side” icon under the “Window” group on the ribbon.
  2. Now, select the workbook from the drop-down, you want to compare in split-screen view and Click OK.
    6-view-side-by-side-option
  3. Once, you click OK, you will get the workbooks to spit view and synchronous scrolling activated by default for the worksheets in the split-screen view.
    7-synchronous-scrolling-option