0 of 62
Getting started·Lesson 4 of 62Free

Jumping to the edge of the data

Jump to the end of your data

What you’ll do

Real sheets can run to thousands of rows. Hold Ctrl (⌘ on a Mac) with an arrow key to jump to the end of the data in one press.

Your turn

Step 1 of 4
  1. 1
    Click E2, then press Ctrl+↓ Mac ⌘+↓. You land on the last order.
  2. 2
    Press Ctrl+→ Mac ⌘+→ to jump to the end of the row.
  3. 3
    Press Ctrl+Home Mac ⌘+Fn+← to go back to A1.
  4. 4
    Add Shift to select as you jump: click F2, then press Ctrl+Shift+↓ Mac ⌘+Shift+↓.

Click the sheet first so it gets your key presses.

A1
ABCDEFGH
1OrderRepRegionProductUnitsPriceOrder dateShip date
21001AnaWestDesk32401/5/20261/9/2026
31002BoEastChair8851/12/20261/20/2026
41003CyWestLamp12301/19/20261/22/2026
51004DiNorthDesk22402/2/20262/13/2026
61005AnaWestChair5852/9/20262/12/2026
71006EveSouthShelf41202/16/20262/27/2026
81007BoEastLamp20303/2/20263/4/2026
91008CyWestShelf11203/9/20263/18/2026
101009DiNorthChair6853/16/20263/19/2026
111010EveSouthDesk72403/23/20264/1/2026
Ctrl+/ shows the shortcuts

Stuck?