Chapter 4 Edit rows and columns; calculate totals ・ MISSION 16
Mission 16: Insert a row
Keycat
Insert one empty row above row 4.
A4fx9/4
A
B
C
D
1
Date
Item
Amount
2
9/1
Transportation expenses
640
3
9/2
Stationery
1200
4
9/4
Transportation expenses
480
5
9/5
Meeting expenses
3200
6
7
8
Keystrokes 0/ Best example: 2
Chapter 4 ・ MISSION 16
Insert a row
Insert one empty row above row 4.
A
B
C
D
1
Date
Item
Amount
2
9/1
Transportation expenses
640
3
9/2
Stationery
1200
4
9/4
Transportation expenses
480
5
9/5
Meeting expenses
3200
6
7
A
B
C
D
1
Date
Item
Amount
2
9/1
Transportation expenses
640
3
9/2
Stationery
1200
4
5
9/4
Transportation expenses
480
6
9/5
Meeting expenses
3200
7
The tutorial is On. You can change this setting on the mission list page. Mission list
Shortcuts used in this mission
- ShiftSpace
- →Ctrl+
Select the row with Shift+Space, then press Ctrl++ to insert a row. 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 drillsExcel shortcut list
Use the keys shown in this simulator. In Excel itself, ribbon letters and some shortcuts differ by language and keyboard layout.