Forum Discussion

Kaila43's avatar
Kaila43
Copper Contributor
Jan 12, 2020

compare two different excel sheets

I have two different worksheets with  same columns and rows. I have to compare the values to see the differences between the two sheets. I have two work with two versions of excel 2010 and 2016 professional.

excel

2 Replies

  • SergeiBaklan's avatar
    SergeiBaklan
    Diamond Contributor
    Jan 13, 2020

    Kaila43 

    If you are on Pro version it shall be Inquire available to compare files

    If you don't see it on ribbon, check File->Options->add-ins->COM add-ins

     

  • Abiola1's avatar
    Abiola1
    MVP
    Jan 13, 2020

    Kaila43

     

    Let say you have data in the two sheets of the captions below

     

    To compare two sheets:

    From the Data 2019 sheet, click on New Window in the View tab to duplicate the workbook

    Click on View Side by Side and select Synchronous scrolling

    Click on Arrange All and select Tiled

    Click OK

    Select Data 2018

    So, when you scroll using the navigation scroll bar, both workbooks moves and you can easily compare the two sheets

     

     

     

Resources