Chapter 3 Edit cells, fill ranges and copy formulas ・ MISSION 13
Mission 13: Fill a formula right
Keycat
Let's copy the profit formula (sales - expenses) in B4 to the May and June columns (C4 to D4).
B4fx=B2-B3
A
B
C
D
E
F
1
April
May
June
2
Sales
120
150
90
3
Expenses
80
95
60
4
Profit
40
5
6
7
Keystrokes 0/ Best example: 3
Chapter 3 ・ MISSION 13
Fill a formula right
Let's copy the profit formula (sales - expenses) in B4 to the May and June columns (C4 to D4).
A
B
C
D
E
F
1
April
May
June
2
Sales
120
150
90
3
Expenses
80
95
60
4
Profit
40
5
A
B
C
D
E
F
1
April
May
June
2
Sales
120
150
90
3
Expenses
80
95
60
4
Profit
40
55
30
5
The tutorial is On. You can change this setting on the mission list page. Mission list
Shortcuts used in this mission
- Shift→
- →Shift→
- →CtrlR
Ctrl+R fills right from the leftmost cell, just as Ctrl+D fills down.
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.