Chapter 2 Entering and editing ・ MISSION 7

Mission 7: Copy the same value to a range

📋 Mission list

Keycat

Put the "Pending" in E2 into every row down to E6.

Keystrokes 0/ Best example: 5

Chapter 2 ・ MISSION 7

Copy the same value to a range

Put the "Pending" in E2 into every row down to E6.

Now
Goal

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

Shortcuts used in this mission

  1. Shift↓
  2. →Shift↓
  3. →Shift↓
  4. →Shift↓
  5. →CtrlEnter

In Sheets, Ctrl+Enter is "Copy to range". It puts the active cell's contents into the whole selection. Pressed while typing, it adds a line break in the cell, so finish typing first.

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.