Chapter 2 Cell navigation and range selection ・ MISSION 6
Mission 6: Jump to the last row
Keycat
The sales table has 30 rows. Jump straight to the last invoice in A30.
Chapter 2 startsCell navigation and range selection
Chapter 2 ・ MISSION 6
Jump to the last row
The sales table has 30 rows. Jump straight to the last invoice in A30.
The tutorial is On. You can change this setting on the mission list page. Mission list
Shortcuts used in this mission
- Ctrl↓
Ctrl+↓ jumps to the bottom of a continuous block of data, even across thousands of rows.
On Mac, use ⌘ (command) instead of Ctrl (control for date, currency display, etc.).
Practise individual shortcuts or check the shortcut reference here. Shortcut drillsExcel shortcut list
Use the keys shown in this simulator. In Excel itself, ribbon letters and some shortcuts differ by language and keyboard layout.
* Some actions may not work depending on your browser environment (for example, shortcuts used by extensions).