Compare two or more worksheets at the same time (2024)

1. On the View tab, in the Window group, click New Window.

   

2. On the View tab, in the Window group, click View Side by Side .

3. In each workbook window, click the sheet that you want to compare.

   See Also

   Resize Excel Worksheet TABSGroup worksheets - Microsoft SupportView Multiple Workbooks in ExcelHow to view sheets side by side in Excel

4. To scroll both worksheets at the same time, click Synchronous Scrolling in the Window group on the View tab.

   Note:This option is available only when View Side by Side is turned on.

1. Open both of the workbooks that contain the worksheets that you want to compare.

2. On the View tab, in the Window group, click View Side by Side .

   

   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.

3. In each workbook window, click the sheet that you want to compare.

4. To scroll both worksheets at the same time, click Synchronous Scrolling in the Window group on the View tab.

   Note:This option is available only when View Side by Side is turned on.

1. Open one or more workbooks that contain the worksheets that you want to view at the same time.

2. Do one of the following:

   • If the worksheets that you want to view are in the same workbook, do the following:

     1. Click a worksheet that you want to view.

        See Also

        Excel Tips: Jump to Any Sheet with a Shortcut

     2. On the View tab, in the Window group, click New Window.

        

     3. Repeat steps 1 and 2 for each sheet that you want to view.

   • If the worksheets that you want to view are in different workbooks, continue with step 3.

3. On the View tab, in the Window group, click Arrange All.

4. Under Arrange, click the option that you want.

5. If the sheets that you want to view are all located in the active workbook, select the Windows of active workbook check box.

Tip:To restore a workbook window to full size, click Maximize at the upper-right corner of the workbook window.

1. On the View tab, in the Window group, click New Window.

   

2. In each workbook window, click the sheet that you want to compare.