COMPARE TWO SHEETS OF SAME FILE IN EXCEL EASILY.
If we want to compare two SHEET in EXCEL file then we can easily compare it. We can easily compile the SHEET of our file SIDE BY SIDE.
To compare two SHEETS we will do the below given STEPS.
Here in the photo below we see a file whose two SHEETS we have to compare.
STEP -1 # For this, we will first CLICK on VIEW TAB.
STEP -2 # After that we will CLICK on NEW WINDOW.
After CLICK on NEW WINDOW, we get a NEW WINDOW.
STEP -3 # After that we will go to VIEW TAB and CLICK on the option of VIEW SIDE BY SIDE.
After CLICK on the option of VIEW SIDE BY SIDE, we see two VIEWs.
STEP -4 # After that we will OPEN the second SHEET in the second WINDOW.
And if we want to HORIZONTALLY this SIDE VIEW to VERTICALLY then we will go into any one window and click on the option ARRANGE ALL in VIEW TAB. And we see an option in which we will SELECT HORIZONTAL from VERTICAL and click on OK.
After that we see an option in which we will SELECT HORIZONTAL from VERTICAL and click on OK.
VIEW of our window becomes HORIZONTAL as soon as CLICK on OK.
And thus we can easily compare the SHEETS of any file. In this, if we move one window from the SIDE BAR, then the SHEET of the other window also moves, which makes it easier to compare the SHEET.