View spreadsheets side by side

Excel 2016 2013 2010 2007 2003
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 be in the same workbook or in the different workbooks.

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

View side by side Excel 365
  • To scroll both worksheets at the same time, click Synchronous Scrolling in the Window group on the View tab:
Synchronous Scrolling in Excel 365
  • 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 the 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, in each workbook window, select the sheet that you want to compare.

If you have any questions or suggestions, please feel free to ask OfficeToolTips team.