Viewing Multiple Places in the Same Worksheet

Excel makes it easy to view different places in the same worksheet. The way you do this is to open additional windows for the worksheet. Display the View tab of the ruler and click New Window in the Window group. Excel opens additional windows that contain the exact same worksheet. You can then click Arrange All in the Window group of the Ribbon to arrange the windows any way desired.

When you open additional windows in this manner, the windows are independent of each other, meaning that you can scroll them independently. If you make a change in one window, the same change is made in all the windows. (This makes sense, since they all display the same data.)

Once the windows are situated the way you want them, you could save the arrangement as a view (Custom Views in the Workbook Views group of the Ribbon). That way you could quickly recall the appearance of your windows any time you desire.