Chapter 4 Inserting, deleting and hiding rows ・ MISSION 18
Mission 18: Group the detail rows
Keycat
Group the detail rows (rows 2 to 6).
A2fxBallpoint pen
A
B
C
D
E
F
1
Product name
Unit price
Quantity
2
Ballpoint pen
120
10
3
Notebook
180
5
4
Sticky notes
250
4
5
Paper clips
90
3
6
File
300
6
7
8
9
10
11
Keystrokes 0/ Best example: 6
Chapter 4 ・ MISSION 18
Group the detail rows
Group the detail rows (rows 2 to 6).
A
B
C
D
E
F
1
Product name
Unit price
Quantity
2
Ballpoint pen
120
10
3
Notebook
180
5
4
Sticky notes
250
4
5
Paper clips
90
3
6
File
300
6
7
8
A
B
C
D
E
F
1
Product name
Unit price
Quantity
2
Ballpoint pen
120
10
3
Notebook
180
5
4
Sticky notes
250
4
5
Paper clips
90
3
6
File
300
6
7
8
The tutorial is On. You can change this setting on the mission list page. Mission list
Shortcuts used in this mission
- ShiftSpace
- →Shift↓
- →Shift↓
- →Shift↓
- →Shift↓
- →AltShift→
Alt+Shift+→ groups and Alt+Shift+← ungroups. Press the − on the left to collapse the grouped rows.
On a Mac, the keys on screen change to Mac keys (⌘, Option, control).
To check shortcuts in a list, see:Google Sheets shortcut list
Keyboard only (the mouse does not work here).
* This simulates the behavior of Google Sheets (Chrome on Windows) and may differ in part from the real thing.
* Google Sheets is a trademark of Google LLC. This site is not affiliated with Google.