In the workbook window, click the worksheets that you want to compare.On the View tab, in the Window group, click View Side by Side.On the View tab, in the Window group, click New Window.View two worksheets in the same workbook side by side in Excel 2007, 2010, 2013 & 2016
