Keyboard shortcuts in Google Sheets - Step-by-Step Guide

Introduction

Keyboard shortcuts help you work faster in Google Sheets by using keys instead of the mouse. They save time when editing, formatting, or navigating your spreadsheet.

When you want to quickly copy and paste data without using the mouse

When you need to undo or redo a change immediately

When you want to move between cells or sheets faster

When you want to quickly insert or delete rows and columns

When you want to open menus or dialogs without clicking

Steps

Step 1: Press Ctrl + C

- any selected cell or range

Copies the selected cells to the clipboard

💡 Use Command + C on Mac

Step 2: Press Ctrl + V

- any cell where you want to paste

Pastes the copied content into the selected cell(s)

💡 Use Command + V on Mac

Step 3: Press Ctrl + Z

- any time after making a change

Undoes the last action you performed

💡 Use Command + Z on Mac

Step 4: Press Ctrl + Y

- after undoing an action

Redoes the action you just undid

💡 Use Command + Y or Command + Shift + Z on Mac

Step 5: Press Ctrl + Arrow keys

- while a cell is selected

Moves the cursor to the edge of data regions in the direction pressed

💡 Use Command + Arrow keys on Mac

Step 6: Press Ctrl + Shift + Plus (+)

- after selecting rows or columns

Inserts new rows or columns above or to the left

💡 Use Command + Shift + Plus (+) on Mac

Step 7: Press Ctrl + /

- anytime in Google Sheets

Opens the keyboard shortcuts help menu showing all shortcuts

💡 Use Command + / on Mac

Before vs After

Before

You use the mouse to copy, paste, undo, and move around cells slowly

After

You use keyboard shortcuts to perform these actions quickly without leaving the keyboard

Settings Reference

Keyboard shortcuts help

📍 Press Ctrl + / (Windows) or Command + / (Mac)

To learn and find all available keyboard shortcuts

Default: Shortcut help menu closed

Common Mistakes

Pressing Ctrl + C without selecting any cells

Nothing is copied because no cells are selected

First click or use arrow keys to select the cells you want to copy, then press Ctrl + C

Trying Windows shortcuts on a Mac without using Command key

Shortcuts use Command key on Mac, so Ctrl shortcuts may not work

Use Command key instead of Ctrl for shortcuts on Mac

Pressing shortcuts too quickly or holding keys too long

Google Sheets may not register the shortcut correctly

Press keys firmly and release quickly for best results

Summary

Keyboard shortcuts speed up your work in Google Sheets by reducing mouse use

Common shortcuts include copy (Ctrl + C), paste (Ctrl + V), undo (Ctrl + Z), and navigation with arrow keys

Remember to use Command key on Mac instead of Ctrl for shortcuts

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