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

Mission 28: Copy visible rows only

📋 Mission list

Keycat

Rows 4 and 5 are hidden. Copy only the visible rows and paste them into D1.

Keystrokes 0/ Best example: 7

Chapter 6 ・ MISSION 28

Copy visible rows only

Rows 4 and 5 are hidden. Copy only the visible rows and paste them into D1.

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. →Alt;
  3. →CtrlC
  4. →→
  5. →→
  6. →→
  7. →CtrlV

Select only visible cells with Alt+; A must-have technique when copying tables that contain hidden or collapsed rows.

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.