How to Compare Two Worksheets at the Same Time

How to Compare Two Worksheets at the Same Time

HomeOther ContentHow to Compare Two Worksheets at the Same Time
ChannelPublish DateThumbnail & View CountActions
Channel Avatar IgoroTech2023-03-17 07:18:35 Thumbnail
298 Views
MS Excel View Side by Side
You can quickly compare two worksheets in the same workbook or in different workbooks by viewing them side by side.
Open both of the workbooks that contain the worksheets that you want to compare.
On the View tab, in the Window group, click View Side by Side Button image.
If you have more than two workbooks open, Excel displays the Compare Side by Side dialog box.
In this dialog box, under Compare Side by Side with, click the workbook that contains the worksheet that you want to compare with your active worksheet, and then click OK.
Now you can scroll any of the worksheet synchronously to compare it and edit any of the cell as you required.
#shorts #IgoroTech #IgoroTec #LearnExcel #ExcelQuickTips #ExcelTips #ExcelTricks #MSExcelTips #MSExcelTricks

Please take the opportunity to connect and share this video with your friends and family if you find it useful.