You can set the scroll area,
In design mode, click the sheet properties and you can select the scroll area there.

10-7-2015 1-09-07 AM.jpg

Unfortunately, the scroll area will not save when you exit the workbook, so you will have to set the scroll area when you open the workbook, with VBA.

This goes into the Workbook Module.
Private Sub Workbook_Open()
    Dim sh As Worksheet
    Set sh = Sheets("Sheet1")
    sh.ScrollArea = Range("A1:AV24").Address
End Sub