When you press Ctrl key and any of the arrow keys (left, right, up or down), you will jump to the last populated cell in that direction. For example, pressing the Ctrl + Down Arrow key wFor example, pressing the Ctrl + Down Arrow key will move downward to the last cell that contains data. This is an excellent way to move quickly to the bottom row in your spreadsheet, especially if your worksheet is lengthy.
If you want to jump no the last populated cell and also select all the cells in between, hold down the Shift key as you press the Ctrl + arrow key. For example, press Shift + Ctrl + Down Arrow to selects all the cells between where you are and the last cell in your worksheet.