Forum Discussion
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 profe...
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