Chapter 3 Pasting and number formats ・ MISSION 9

Mission 9: Paste the amounts as values only

📋 Mission list

Keycat

Copy the amounts (D2 to D6) and paste them into F2 as values only.

Keystrokes 0/ Best example: 5

Chapter 3 startsPasting and number formats

Chapter 3 ・ MISSION 9

Paste the amounts as values only

Copy the amounts (D2 to D6) and paste them into F2 as values only.

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. →CtrlShiftV

Ctrl+Shift+V pastes values only. You get the results, not formulas, so the numbers stay the same even if the referenced cells change. One step, without opening Excel's Paste Special.

On a Mac, the keys on screen change to Mac keys (⌘, Option, control).

To check shortcuts in a list, see:Google Sheets shortcut list

Keyboard only (the mouse does not work here).

* This simulates the behavior of Google Sheets (Chrome on Windows) and may differ in part from the real thing.

* Google Sheets is a trademark of Google LLC. This site is not affiliated with Google.