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