If you select a cell, the shift and the down arrow, you can select many cells at one time. If you continue to move down while holding the shift key, the sheet will not scroll with the highlighted cell. If the screen scrolled, the user can see where in the sheet the highlighted cell is and will know when to stop