When you want to view two different parts of your spreadsheet at once, you can use Split.
Split is found in the View Menu, Window Section. (Shortcut Key Alt, W, S)
Split will cut your spreadsheet into four based on the current active cell. Scroll up and down will move both the left and right parts of the section you are in. Scrolling left and right will scroll both the upper and lower parts of the section you are in. It takes a bit of getting used to, but can be very handy if you have data in different places of your sheet that you want to be able to see at the same time.
To turn off the Split, click Split again. (Shortcut Key Alt, W, S)