Excel ENABLE END MODE Keyboard Shortcut

Using the Enable End Mode Shortcut

Windows keyboard shortcut

Mac keyboard shortcut

Use this shortcut to enable end mode. When using end mode arrow keys take you further across the spreadsheet. When End Mode is enabled, pressing an arrow key will navigate you to the first non-blank or blank cell in the same row or column.
Other useful Navigation keyboard shortcuts