Keyboard shortcuts in Google Sheets - Cheat Sheet & Quick Revision

Recall & Review

beginner

What shortcut do you use to copy selected cells in Google Sheets?

Press Ctrl + C (Windows) or Cmd + C (Mac) to copy selected cells.

beginner

How do you quickly paste copied content in Google Sheets?

Use Ctrl + V (Windows) or Cmd + V (Mac) to paste copied content into the selected cell.

beginner

Which shortcut allows you to undo your last action?

Press Ctrl + Z (Windows) or Cmd + Z (Mac) to undo the last action.

intermediate

How can you insert a new row above the current row using a shortcut?

Press Ctrl + Shift + + (Windows) or Cmd + Shift + + (Mac) to insert a new row above the selected row.

intermediate

What shortcut helps you quickly find and replace text or values in your sheet?

Press Ctrl + H (Windows) or Cmd + Shift + H (Mac) to open the Find and Replace dialog.

Which shortcut copies the selected cells in Google Sheets?

A Ctrl + C

B Ctrl + V

C Ctrl + X

D Ctrl + Z

Ctrl + C copies the selected cells, while Ctrl + V pastes, Ctrl + X cuts, and Ctrl + Z undoes.

How do you undo your last action quickly?

A Ctrl + Z

B Ctrl + S

C Ctrl + Y

D Ctrl + P

Ctrl + Z undoes the last action in Google Sheets.

Which shortcut opens the Find and Replace dialog?

A Ctrl + R

B Ctrl + F

C Ctrl + H

D Ctrl + D

Ctrl + H opens Find and Replace, while Ctrl + F only finds text.

To insert a new row above the current one, which shortcut is correct?

A Ctrl + Shift + =

B Ctrl + Shift + +

C Ctrl + Enter

D Ctrl + Shift + R

Ctrl + Shift + + inserts a new row above the selected row.

What shortcut pastes copied content?

A Ctrl + C

B Ctrl + Z

C Ctrl + X

D Ctrl + V

Ctrl + V pastes copied content into the selected cell.

List three essential keyboard shortcuts for editing cells in Google Sheets and explain what each does.

Think about how you copy, paste, and fix mistakes quickly.

Explain how to insert a new row using a keyboard shortcut and why this might save time.

Focus on shortcuts that add rows without using the mouse.

Practice

1. Which keyboard shortcut in Google Sheets is used to undo the last action?

easy

A. Ctrl + Z (Command + Z on Mac)

B. Ctrl + Y (Command + Y on Mac)

C. Ctrl + C (Command + C on Mac)

D. Ctrl + V (Command + V on Mac)

Solution

1. Step 1: Understand the undo function

   Undo reverses the last change made in the sheet.

2. Step 2: Identify the correct shortcut

   Ctrl + Z (or Command + Z on Mac) is the standard undo shortcut in Google Sheets.

3. Final Answer:

   Ctrl + Z (Command + Z on Mac) -> Option A

4. Quick Check:

   Undo = Ctrl + Z [OK]

Hint: Undo is always Ctrl + Z or Command + Z on Mac [OK]

Common Mistakes:

• Confusing undo with redo shortcut
• Using copy or paste shortcuts instead
• Trying Ctrl + Y for undo instead of redo

2. Which of the following is the correct keyboard shortcut to copy selected cells in Google Sheets?

easy

A. Ctrl + C

B. Ctrl + V

C. Ctrl + X

D. Ctrl + Z

Solution

1. Step 1: Recall the copy shortcut

   Copy duplicates the selected content without removing it.

2. Step 2: Match the shortcut to copy

   Ctrl + C (Command + C on Mac) is the standard copy shortcut.

3. Final Answer:

   Ctrl + C -> Option A

4. Quick Check:

   Copy = Ctrl + C [OK]

Hint: Copy is always Ctrl + C or Command + C on Mac [OK]

Common Mistakes:

• Mixing copy with paste shortcut
• Using cut shortcut instead of copy
• Confusing undo shortcut with copy

3. If you want to quickly select an entire column in Google Sheets, which shortcut should you use?

medium

A. Shift + Space

B. Alt + Space

C. Ctrl + A

D. Ctrl + Space

Solution

1. Step 1: Understand selection shortcuts

   Ctrl + Space selects the entire column of the active cell.

2. Step 2: Identify the correct shortcut

   Ctrl + Space is the standard shortcut for selecting a column in Google Sheets.

3. Final Answer:

   Ctrl + Space -> Option D

4. Quick Check:

   Select column = Ctrl + Space [OK]

Hint: Select column quickly with Ctrl + Space [OK]

Common Mistakes:

• Using Shift + Space which selects a row
• Trying Ctrl + A which selects all cells
• Confusing Alt + Space with other shortcuts

4. You tried to paste copied cells using Ctrl + P in Google Sheets, but it didn't work. What is the correct shortcut to paste?

medium

A. Ctrl + X

B. Ctrl + P

C. Ctrl + V

D. Ctrl + C

Solution

1. Step 1: Identify the paste shortcut

   Paste inserts copied content into the selected cells.

2. Step 2: Correct the wrong shortcut

   Ctrl + V (Command + V on Mac) is the correct paste shortcut, not Ctrl + P.

3. Final Answer:

   Ctrl + V -> Option C

4. Quick Check:

   Paste = Ctrl + V [OK]

Hint: Paste is Ctrl + V, not Ctrl + P [OK]

Common Mistakes:

• Using Ctrl + P which is print
• Confusing paste with copy or cut
• Trying Ctrl + X which cuts instead of pastes

5. You want to quickly insert a new row above the current row in Google Sheets without using the mouse. Which keyboard shortcut should you use?

hard

A. Ctrl + Alt + Down Arrow

B. Ctrl + Shift + Plus (+)

C. Ctrl + Shift + Minus (-)

D. Ctrl + Enter

Solution

1. Step 1: Understand inserting rows shortcut

   Ctrl + Shift + Plus (+) inserts a new row or column depending on selection.

2. Step 2: Confirm the correct shortcut for new row

   Using Ctrl + Shift + Plus (+) with a selected row inserts a new row above.

3. Final Answer:

   Ctrl + Shift + Plus (+) -> Option B

4. Quick Check:

   Insert row = Ctrl + Shift + + [OK]

Hint: Insert row with Ctrl + Shift + + (plus) [OK]

Common Mistakes:

• Using Ctrl + Shift + Minus which deletes rows
• Trying Ctrl + Enter which edits cell
• Confusing with arrow key shortcuts