View spreadsheets side by side

Excel 2016
Sometimes it is necessary to compare two Excel worksheets. E.g., compare balance sheets for different periods of time. You can do it by comparing spreadsheets side by side in two automatically linked windows.

The sheets can reside in the same workbook or different workbooks.

On the View tab, in the Window group, click the View Side by Side button:

View side by side Excel 365

Excel automatically activates the Synchronous Scrolling mode, and scrolling in one of the windows also scrolls the other window. So, the Synchronous Scrolling button in the Window group on the View tab is highlighted:

Synchronous Scrolling in Excel 365
  • If you don't need simultaneous scrolling, click the Synchronous Scrolling button in the Window group on the View tab to unselect it.
  • If you resize the workbook windows, click Reset Window Position to return to the original settings.
  • To close the Side by Side view, click View Side by Side again.

Notes:

  1. To view side by side spreadsheets of the same workbook, open this workbook with needed spreadsheets in multiple windows. See Viewing a worksheet in multiple windows for more details.
  2. If more than two workbooks are open, after clicking the View Side by Side button, Excel displays the Compare Side by Side dialog box:
    Compare Side by Side in Excel 365
    • Under Compare Side by Side with, select the workbook with a spreadsheet that you want to compare with the active worksheet,
    • Click OK,
    • If needed, select the sheet you want to compare in each workbook window.

See also this tip in French: Comment afficher les feuilles de calcul côte à côte.

Please, disable AdBlock and reload the page to continue

Today, 30% of our visitors use Ad-Block to block ads.We understand your pain with ads, but without ads, we won't be able to provide you with free content soon. If you need our content for work or study, please support our efforts and disable AdBlock for our site. As you will see, we have a lot of helpful information to share.