How to compare two Excel spreadsheets

Written by nina nixon Google
  • Share
  • Tweet
  • Share
  • Pin
  • Email
How to compare two Excel spreadsheets
Side-by-side comparisons enable better data input.

Comparing two Excel spreadsheets is useful for analysing the differences and similarities in data. By using the View Side by Side option, you minimise the burden of matching the location of similar data or like categories and increase accuracy in reading factual data needed to make visual comparisons. When you use the option to view two excel spreadsheets next to one another, Excel automatically enables synchronous scrolling. This feature makes it easy to view the exact same information in both spreadsheets at the same time. You can also turn this option off, as needed.

Skill level:


  1. 1

    Open Excel and use "File," and then "Open" to open the first file to use for comparison.

  2. 2

    While the first document is still open, use "File," and then "Open" to open the second file.

  3. 3

    Select the "View" tab, and then select "New Window."

  4. 4

    Select "View Side by Side."

Tips and warnings

  • To remove synchronous scrolling, click the icon. Turning off this options lets you scroll inside the first document, while the second one remains stationary.
  • Referring to Step 5, the "Reset Position Window" option only works with a maximum of two open workbooks at a time. When there are more than two, it will reset to comparing the fist two workbooks that were originally opened first, and remove any and all others from the "Compare Side by Side With" position window.

Don't Miss

  • All types
  • Articles
  • Slideshows
  • Videos
  • Most relevant
  • Most popular
  • Most recent

No articles available

No slideshows available

No videos available

By using the site, you consent to the use of cookies. For more information, please see our Cookie policy.