The End key is to turn the End mode on or off. In End mode, you can use the arrow key to move to the next nonblank cell or the last cell in a blank sheet.
Step 1: Click any cell in the worksheet;
Step 2: Press the End key to turn the End model on. Press the right arrow, and the cursor will move the last cell in the same row;
Step 3: Press the down arrow, and the cursor will move to the last cell in the same column.
This is one part of it.
What is the "End Mode" that appearing on right clicking the bottom status bar? What it means when that is ticked or untickes, and how to turn that off?
or is that related to what you explained above?