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

Mission 31: Paste one table’s formatting onto another

📋 Mission list

Keycat

Paste only the formatting of the September table (A1–C4) onto the October table (A6–C9). Keep the October numbers as they are.

Keystrokes 0/ Best example: 7

Chapter 6 ・ MISSION 31

Paste one table’s formatting onto another

Paste only the formatting of the September table (A1–C4) onto the October table (A6–C9). Keep the October numbers as they are.

Now
Goal

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

Shortcuts used in this mission

  1. CtrlA
  2. →CtrlC
  3. →Ctrl↓
  4. →Ctrl↓
  5. →CtrlAltV
  6. →T
  7. →Enter

Ctrl+Alt+V → T → Enter pastes formatting only. Bold and currency formats line up without touching the contents.

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.