It can be done and I'll show you how, but you must enter the Visual Basic Editor. It's actually a very simple operation.
I will give instructions as if you have never been in the Visual Basic Editor.
First Press Alt-F11 to enter the Visual Basic Editor.
A new window should pop up that is the Visual Basic Editor (which I'll refer to as VBE now).
In the upper left corner of the VBE window you should see a section that says VBA Project with the name of your workbook in parentheses. You will see a tree structure showing all the different worksheets in your workbook. Click on the worksheet name that you want to limit scrolling. If you have re-named Sheet 1 to be called "Data" it will be shown as "Sheet 1 (Data)"
The section below that is called "Properties" and it should say the name of the worksheet you selected. In that section you should see a list of properties for the worksheet. Look for one called ScrollArea which is about the 9th or 10th item down. In the blank space to the right of that, type in the range that you would like to limit scrolling to. So if you want to limit scrolling to the range of A1:Z999, type that in. Then press Tab to exit that box. Then you can close the VBE window completely and that one particular worksheet should be limited to scrolling to that area.
To change it, just go back and use the same instructions as above. To reset it to the way it was, go back and delete the range information you entered. To alter the scrolling area of another worksheet, just select another worksheet.
There are a few other neat things you can do with the VBE without having to do any Visual Basic programming.
Hope this helps!
Dave