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

Mission 29: Paste formula results as values

📋 Mission list

Keycat

Copy the next-period target formulas in column C and paste only their values into column E.

Keystrokes 0/ Best example: 7

Chapter 6 ・ MISSION 29

Paste formula results as values

Copy the next-period target formulas in column C and paste only their values into column E.

Now
Goal

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

Shortcuts used in this mission

  1. CtrlShift↓
  2. →CtrlC
  3. →→
  4. →→
  5. →CtrlAltV
  6. →V
  7. →Enter

Ctrl+Alt+V to Paste Special, V to Value, Enter. Standard when separating formulas for reporting.

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.