Shortcut Keys for Data Selection

CTRL+SHIFT+END extends the selection of cells to the last used cell on the worksheet (lower-right corner). ENTER Completes a cell entry from the cell or the Formula Bar, and selects the cell below (by default). ................
................