How to Match Data in Excel Spreadsheets

Written by bonnie conrad
  • Share
  • Tweet
  • Share
  • Pin
  • Email
How to Match Data in Excel Spreadsheets
You can match two spreadsheets. (computer image by blaine stiger from

Microsoft Excel can be a powerful tool for data analysis, and it can be even more useful when workers are able to match two spreadsheets side-by-side. Matching two separate spreadsheets is one of the best ways users have to spot erroneous data, analyse differences in information and make sense of complex data. Microsoft Excel provides a feature designed specifically to allow users to compare and match two spreadsheets side-by-side.

Skill level:


  1. 1

    Log on to your computer and open Microsoft Excel. Open the first spreadsheet you want to match.

  2. 2

    Open the second spreadsheet. Once both spreadsheets are open, click the "Window" menu.

  3. 3

    Choose the "Compare Side by Side" option to see both of the spreadsheets side by side. Place your cursor on the top bar of each spreadsheet and move it around in the window until it is in the position you want. Do the same with the other spreadsheet until you can easily see them side-by-side.

  4. 4

    Scroll through both spreadsheets, looking for differences in the data as you go. Note any changes that need to be made in one or both spreadsheets, then save both spreadsheets to preserve your changes.

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.