Chapter 4 Edit rows and columns; calculate totals ・ MISSION 17
Mission 17: Remove unnecessary columns
Keycat
I no longer use "Memo" in column C. Let's delete column C entirely.
C1fxNotes
A
B
C
D
E
1
Date
Item
Notes
Amount
2
9/1
Transportation expenses
Draft
640
3
9/2
Stationery
1200
4
9/4
Transportation expenses
Checking
480
5
6
7
Keystrokes 0/ Best example: 2
Chapter 4 ・ MISSION 17
Remove unnecessary columns
I no longer use "Memo" in column C. Let's delete column C entirely.
A
B
C
D
E
1
Date
Item
Notes
Amount
2
9/1
Transportation expenses
Draft
640
3
9/2
Stationery
1200
4
9/4
Transportation expenses
Checking
480
5
A
B
C
D
E
3
9/2
Stationery
1200
4
9/4
Transportation expenses
480
5
6
7
The tutorial is On. You can change this setting on the mission list page. Mission list
Shortcuts used in this mission
- CtrlSpace
- →Ctrl-
Select a column with Ctrl+Space and delete with Ctrl+- (Ctrl + minus).
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.