Record a macro in Excel (Tools>Macros>record)
scroll the sheet down
Stop recording
Tools>Macros>VBA editor to see the code, and use the parts you need to scroll the view of the sheet up and down as required.

Hope that helps you