Page 273 - Excel 2013 All-in-One For Dummies

Reorganizing the Workbook 255 Comparing worksheet windows side by side
Figure 4-11 helps illustrate how the View Side by Side feature works. This figure contains two windows showing parts of two different worksheets (2010 Sales and 2011 Sales) in the same workbook (CG Media Sales 2010 - 12.xlsx). These windows are arranged horizontally so that they fit one above the other and in order to show more data, I have unpinned the Ribbon in both windows so that only the row of tabs are visible.
Figure 4-11:
Using windows to compare data stored on two different sheets in the same workbook.
As you can see, the top window shows the upper-left portion of the first worksheet with the 2010 sales data, while the lower window shows the upper-left portion of the second worksheet with the 2011 sales data. Note that both windows contain the same sheet tabs (although different tabs
are active in the different windows) but that only the top, active window is equipped with a set of horizontal and vertical scroll bars. However, because Excel automatically synchronizes the scrolling between the windows, you can use the single set of scroll bars to bring different sections of the two sheets into view.
Book II Chapter 4
Managing Worksheets