Answered By: Katie Hutchison
Last Updated: Aug 16, 2018     Views: 94793

View two worksheets in the same workbook side by side in Excel 2007, 2010, 2013 & 2016

  1. On the View tab, in the Window group, click New Window.
  1. On the View tab, in the Window group, click View Side by Side .
  2. In the workbook window, click the worksheets that you want to compare.
  3. 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.

Tips

  • If you resize the workbook windows for optimal viewing, you can click Reset Window Position to return to the original settings.
  • To restore a workbook window to full size, click Maximize at the upper-right corner of the workbook window.

 

View two worksheets of different workbooks side by side

  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.

Window goup on Excel Ribbon

 Note   If you keep 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.

  1. In each workbook window, click the sheet that you want to compare.
  2. 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.

Tips

  • If you resize the workbook windows for optimal viewing, you can click Reset Window Position to return to the original settings.
  • To restore a workbook window to full size, click Maximize at the upper-right corner of the workbook window.

 

View multiple worksheets at the same time

  1. Open the workbook or 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.
      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. To view sheets only 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.

Comments (5)

  1. Thank you! Great instructions.
    by Sheilah A. on Jul 13, 2017.
  2. Is there a way to save the view side by side setting so that when you bring the worksheet or workbooks back up they appear side by side? I know that there is the save workplace option, but that seems to save all files that you had opened at the time.
    by Greg on Aug 15, 2018.
  3. @Greg - I've never heard of being able to do that and still have the excel sheets usable.

    If you want a still image of the side by side you could do a screenshot or use a program like the snipping tool.
    by Katie Hutchison on Aug 16, 2018.
  4. It was the best useful answer that I've got
    by Sanaz on Feb 06, 2019.
  5. Can we run the VB code and scroll through the excel file simultaneously?
    by Manan on Jun 24, 2019.

Contact Us!

Main Library: (330) 490-7185

Questions? Ask Us!

Related Topics