Chapter 2 Cell navigation and range selection ・ MISSION 9
Mission 9: Select and bold an entire row
Keycat
The entertainment expense in row 5 needs attention. Make the entire row bold.
A5fx9/5
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
Entertainment expenses
8600
6
9/8
Transportation expenses
320
7
8
Keystrokes 0/ Best example: 2
Chapter 2 ・ MISSION 9
Select and bold an entire row
The entertainment expense in row 5 needs attention. Make the entire row bold.
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
Entertainment expenses
8600
6
9/8
Transportation expenses
320
7
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
Entertainment expenses
8600
6
9/8
Transportation expenses
320
7
The tutorial is On. You can change this setting on the mission list page. Mission list
Shortcuts used in this mission
- ShiftSpace
- →CtrlB
Shift+Space selects the entire row. Ctrl+Space selects the entire column.
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.