Chapter 7 Use Alt for column widths, borders and view settings ・ MISSION 34

Mission 34: Freeze heading and left column

📋 Mission list

FileHomeInsertPage LayoutFormulasDataReviewViewPress and release Alt for key hints.

Keycat

Freeze panes so that the header in row 1 and invoice numbers in column A stay visible when you scroll.

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: 6

Chapter 7 ・ MISSION 34

Freeze heading and left column

Freeze panes so that the header in row 1 and invoice numbers in column A stay visible when you scroll.

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

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

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

Shortcuts used in this mission

↓
→→
→Alt
→W
→F
→F

From B2, press Alt → W → F → F. This freezes the rows above and columns to the left of the active cell.

This is an operation for the Windows version of Excel (the Mac version of Excel does not have ribbon key tips).

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.