View spreadsheets side by side

Excel 365 2016 2013 2010 2007
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 worksheets side by side in two automatically linked windows.

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

First, make sure that the two sheets are displayed in separate windows. If you want to compare two sheets in the same workbook, use the Window -> New Window command to create a new window for the active workbook. Activate the first window; then choose Window -> Compare Side by Side With. If more than two windows are open, you'll see a dialog box that lets you select the window for the comparison.

Compare in Excel 2003

The two windows will be tiled horizontally, not really "side by side." If you prefer a true side-by-side arrangement, select Window -> Arrange, and select Vertical in the Arrange Windows dialog box.

Vertical in Excel 2003

When using the Compare Side by Side feature, you'll find that scrolling in one of the windows also scrolls the other window. When you use this command, the Compare Side by Side toolbar is displayed. This toolbar contains the following buttons:

Compare Side by Side in Excel 2003
  • Synchronous Scrolling: Toggles automatic windows scrolling on and off.
  • Reset Window Position: If you have rearranged or moved the windows, clicking this button puts them back in the initial horizontal arrangement.
  • Close Side by Side: Breaks out of side-by-side mode and returns to the previous window positions. You can also use the Window -> Break Side by Side command for this.

Keep in mind that this feature is for manual comparison only. Unfortunately, Excel does not provide a way to show you the differences between two sheets.

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

We use cookies to personalise content and ads, to provide social media features and to analyse our traffic. We also share information about your use of our site with our social media, advertising and analytics partners who may combine it with other information you’ve provided to them or they’ve collected from your use of their services.

Learn more