Here are the best uses of the Arrow keys in Excel with Scroll Lock mode turned on. Pressing Ctrl+Shift+Up, Down, Left, or Right Arrows selects the current cell and all cells above, below, to the left, ...
If you're working on a long scrolling spreadsheet, use "Freeze panes" to get your column headings to stick around when you scroll down through rows of data. First, place your cursor in column A row 2.