Chapter 4 Edit rows and columns; calculate totals ・ MISSION 16

Mission 16: Insert a row

📋 Mission list

Keycat

Insert one empty row above row 4.

A4fx9/4

Date

Item

Amount

9/1

Transportation expenses

640

9/2

Stationery

1200

9/4

Transportation expenses

480

9/5

Meeting expenses

3200

Keystrokes 0/ Best example: 2

Chapter 4 startsEdit rows and columns; calculate totals

Chapter 4 ・ MISSION 16

Insert a row

Insert one empty row above row 4.

Now

Date

Item

Amount

9/1

Transportation expenses

640

9/2

Stationery

1200

9/4

Transportation expenses

480

9/5

Meeting expenses

3200

Goal

Date

Item

Amount

9/1

Transportation expenses

640

9/2

Stationery

1200

9/4

Transportation expenses

480

9/5

Meeting expenses

3200

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

Shortcuts used in this mission

ShiftSpace
→CtrlShift+

Select the row with Shift+Space, then press Ctrl+Shift++ (the + key) to insert it. For a column, select it with Ctrl+Space first.

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).