Ctrl + ARROW KEY
Ctrl + SHIFT + ARROW KEY
The Tip: implementing the Ctrl and Shft key in your artillery of keyboard shortcut can be one of the most useful and important ones to speed up productivity of your excel project.
The Trick: there are three different ways to utilize the arrow keys in Excel
- Arrow Keys (only): one key stroke moves the cursor in the direction of the Arrow Key.
- Holding Ctrl + Arrow Keys: one key stroke on the arrow key while holding the “Ctrl” key will move the cursor to the last “non-blank” cell right before the next “blank” cell.