COMPARE TWO SHEETS

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.

COMPARE TWO SHEETS

STEP -1 # For this, we will first CLICK on VIEW TAB.

COMPARE TWO SHEETS

STEP -2 # After that we will CLICK on NEW WINDOW.

COMPARE TWO SHEETS

After CLICK on NEW WINDOW, we get a NEW WINDOW.

COMPARE TWO SHEETS

STEP -3 # After that we will go to VIEW TAB and CLICK on the option of VIEW SIDE BY SIDE.

COMPARE TWO SHEETS

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.

COMPARE TWO SHEETS

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.

COMPARE TWO SHEETS

After that we see an option in which we will SELECT HORIZONTAL from VERTICAL and click on OK.

COMPARE TWO SHEETS
COMPARE TWO SHEETS

VIEW of our window becomes HORIZONTAL as soon as CLICK on OK.

COMPARE TWO SHEETS

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.

For more information see VIDEO -

Leave a Reply

© 2020 NtOffice.in         ।     All Rights Reserved.

ABOUT US    ।    CONTACT   US   ।    TERMS  OF  USES   ।  DISCLAIMER   ।  PRIVACY  POLICY

WhatsApp
Google+
Facebook
Telegram