Chapter 6 Filter data, use absolute references and paste values ・ MISSION 30

Mission 30: Paste formulas only, keeping the formatting

📋 Mission list

Keycat

Paste the tax-included formulas in column C into column E as formulas only. Keep the bold formatting in column E.

C2fx=B2*1.1

Item

Sep

Sep incl. tax

Oct

Oct incl. tax

Stationery

1000

¥1,100

2000

Transportation expenses

3000

¥3,300

5000

Communication expenses

4000

¥4,400

6000

Keystrokes 0/ Best example: 7

Chapter 6 ・ MISSION 30

Paste formulas only, keeping the formatting

Paste the tax-included formulas in column C into column E as formulas only. Keep the bold formatting in column E.

Now

Item

Sep

Sep incl. tax

Oct

Oct incl. tax

Stationery

1000

¥1,100

2000

Transportation expenses

3000

¥3,300

5000

Communication expenses

4000

¥4,400

6000

Goal

Item

Sep

Sep incl. tax

Oct

Oct incl. tax

Stationery

1000

¥1,100

2000

2200

Transportation expenses

3000

¥3,300

5000

5500

Communication expenses

4000

¥4,400

6000

6600

The tutorial is On. You can change this setting on the mission list page. Mission list

Shortcuts used in this mission

CtrlShift↓
→CtrlC
→→
→→
→CtrlAltV
→F
→Enter

Ctrl+Alt+V → F → Enter pastes formulas only. The destination keeps its own formatting.

On Mac, use ⌘ (command) instead of Ctrl (control for date, currency display, etc.).

Practise individual shortcuts or check the shortcut reference here. Shortcut drills Excel shortcut list

Use the keys shown in this simulator. In Excel itself, ribbon letters and some shortcuts differ by language and keyboard layout.