About This Shortcut
This shortcut enables and disables “End mode”. In End mode, arrow keys move you farther across the worksheet. In End mode, pressing an arrow key will take the cursor to the first nonblank or blank cell in the same row or column.
About This Shortcut
To navigate back to a hyperlink, after clicking the link, you can use a two step-process: (1) use the shortcut control + G to bring up the Go To dialog box, (2) press Enter to go back to the hyperlink. This works because the Go To dialog records the hyperlink location when a hyperlink is clicked. Then the Go To dialog box is opened, this location will appear in the “Reference” input area. When the enter key is pressed, Excel will navigate to the recorded location.