How to open, view and compare two Excel worksheets side by side?


A pretty helpful function when working with spreadsheets is the ability to compare them side by side.In today’s tutorial  we’ll show you how to view and compare two or more worksheets in the same or different workbooks side by side.

View two worksheets in same workbook:

  • Open your excel spreadsheet which consists of two workbooks.
  • Now click on New Window and we can see that same workbook is opened twice.

2015-11-30 14_04_39-Mini Proj_1  [Compatibility Mode] - Excel

  • It allows us to work with different workbook at the same time.

2015-11-30 14_05_16-Mini Proj_2  [Compatibility Mode] - Excel

  • Then click on View side by side in the View ribbon, which allows us to view same workbook side by side.

2015-11-30 14_05_58-Mini Proj_1  [Compatibility Mode] - Excel



  • Click on different worksheet on the same workbook and compare with the other one.
  • Go to View and select Synchronous scrolling will allow us to scroll on both sheets at the same time.

2015-11-30 14_08_08-Mini Proj_1  [Compatibility Mode] - Excel

  • Move the worksheet if needed and click on Reset window position to make sheet go back to it’s original position.

2015-11-30 14_09_15-

Open two worksheets from different workbooks:

  • Open the two excel spreadsheets which has to be viewed and compared side by side.

2015-11-30 14_10_46-Book1 - Excel

  • Then do the same process done for two worksheets on same workbook.
  • Click on View side by side in the View ribbon, which allows us to view same workbook side by side.

2015-11-30 14_11_24-Mini Proj  [Compatibility Mode] - Excel

  • Click on different worksheet on the same workbook and compare with the other one.
  • Go to View and Synchronous scrolling will allow us to scroll on both sheets at the same time.

2015-11-30 14_08_08-Mini Proj_1  [Compatibility Mode] - Excel

  • Move the worksheet if needed and click on Reset window position to make sheet go back to it’s original position.

2015-11-30 14_09_15-

Compare multiple worksheets:

  • Open two or more worksheets of different workbook, click on Arrange on and select how it has to be arranged.
  • If two or more worksheets on same workbook, then click on the new window accordingly to the no of worksheets.
  • Then click on Arrange on and select how is has to be arranged.

2015-11-30 14_13_51-Mini Proj  [Compatibility Mode] - Excel

Thus we can use the side by side view for workbooks. Thanks for reading :)

Leave a Comment: