Try Shift+Enter. This will keep your selection but move the active cell to the end of the selection.


Do this using BOTTOM-UP Approach

Steps to follow:

  1. Press CTRL+DOWN ARROW continueously
  2. Now you have reached to the last row of the excel sheet
  3. Press CTRL+UP ARROW to reach to the last row of the record

UPDATE:

Use this short-cut key:

CTRL+SHIFT+DOWN ARROW


Jumping corner-to-corner inside the selected range:

Ctrl+.

https://www.excelcampus.com/keyboard-shortcuts/jump-to-last-cell-selected-range/