Chapter 2 Cell navigation and range selection ・ MISSION 8

Mission 8: Jump to the last used cell

📋 Mission list

Keycat

Let's move to the bottom right cell (C30) in the range that contains data.

A1fxInvoice

Invoice

Owner

Amount

S-001

Sato

1200

S-002

Suzuki

4900

S-003

Takahashi

8600

S-004

Tanaka

3300

S-005

Sato

7000

S-006

Suzuki

1700

S-007

Takahashi

5400

S-008

Tanaka

9100

S-009

Sato

3800

S-010

Suzuki

7500

S-011

Takahashi

2200

Keystrokes 0/ Best example: 1

Chapter 2 ・ MISSION 8

Jump to the last used cell

Let's move to the bottom right cell (C30) in the range that contains data.

Now

Invoice

Owner

Amount

S-001

Sato

1200

S-002

Suzuki

4900

S-003

Takahashi

8600

S-004

Tanaka

3300

S-005

Sato

7000

S-006

Suzuki

1700

S-007

Takahashi

5400

S-008

Tanaka

9100

Goal

S-021

Sato

3200

S-022

Suzuki

6900

S-023

Takahashi

1600

S-024

Tanaka

5300

S-025

Sato

9000

S-026

Suzuki

3700

S-027

Takahashi

7400

S-028

Tanaka

2100

S-029

Sato

5800

The tutorial is On. You can change this setting on the mission list page. Mission list

Shortcuts used in this mission

CtrlEnd

Ctrl+End to go to the last cell of data (bottom right). Also useful when checking the size of a table.

On Mac, use ⌘ (command) instead of Ctrl (control for date, currency display, etc.).

Practise individual shortcuts or check the shortcut reference here. Shortcut drills Excel 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).