Forum Discussion
Multiple Work Sheet row syncing.
On the ribbon, go to the View tab and click New Window (in the Window Section). This will open a second window of the active workbook (you'll notice the title bar will now say "Book1:2" or "Book1 - 2", depending on your version of Excel). Then, in the same section of the View tab, click View Side by Side. When you first do this, the Synchronous Scrolling button should also be activated, but if it's not, then click it. If the default arrangement of the windows is not ideal, click Arrange All (in the same section of the View tab again), then choose the desired window arrangement, check the box for "Windows of active workbook" and click OK.
NOTE: you can create as many "New Windows" as you want, however, the Synchronous Scrolling option can only be used with two (2) windows at the same time.
On the ribbon, go to the View tab and click New Window (in the Window Section). This will open a second window of the active workbook (you'll notice the title bar will now say "Book1:2" or "Book1 - 2", depending on your version of Excel). Then, in the same section of the View tab, click View Side by Side. When you first do this, the Synchronous Scrolling button should also be activated, but if it's not, then click it. If the default arrangement of the windows is not ideal, click Arrange All (in the same section of the View tab again), then choose the desired window arrangement, check the box for "Windows of active workbook" and click OK.
NOTE: you can create as many "New Windows" as you want, however, the Synchronous Scrolling option can only be used with two (2) windows at the same time.
