📊Google Sheets Keyboard Shortcuts
26 essential shortcuts for Google Sheets
General
| Shortcut | Action |
|---|---|
| Ctrl+//⌘/ | Show keyboard shortcuts list |
| Ctrl+Z/⌘Z | Undo |
| Ctrl+Y/⌘Y | Redo |
| Ctrl+Shift+V/⌘⇧V | Paste values only |
Navigation
| Shortcut | Action |
|---|---|
| Tab/Shift+Tab | Move to next / previous cell |
| Enter/Shift+Enter | Move down / up a cell |
| Ctrl+Home/⌘Home | Go to beginning of sheet |
| Ctrl+End/⌘End | Go to last cell with data |
| Ctrl+G/⌘G | Go to range |
| Ctrl+Shift+Page Down/Up | Switch to next / previous sheet |
Formatting
| Shortcut | Action |
|---|---|
| Ctrl+B/⌘B | Bold |
| Ctrl+I/⌘I | Italic |
| Ctrl+U/⌘U | Underline |
| Ctrl+Shift+1 | Format as decimal |
| Ctrl+Shift+4 | Format as currency |
| Ctrl+Shift+5 | Format as percent |
Editing
| Shortcut | Action |
|---|---|
| Ctrl+Enter/⌘↩ | Fill down |
| Ctrl+D/⌘D | Fill down (from cell above) |
| Ctrl+R/⌘R | Fill right (from cell left) |
| Ctrl+;/⌘; | Insert current date |
| Ctrl+Shift+;/⌘⇧; | Insert current time |
| Ctrl+K/⌘K | Insert link |
| Ctrl+Alt+M/⌘⌥M | Insert comment/note |
| F2 | Edit cell (enter edit mode) |
Selection
| Shortcut | Action |
|---|---|
| Ctrl+Space | Select entire column |
| Shift+Space | Select entire row |
About Google Sheets Shortcuts
Google Sheets is Google's cloud-based spreadsheet application supporting real-time collaboration, formulas, charts, pivot tables, and add-ons. It works in the browser with automatic saving to Google Drive. Google Sheets keyboard shortcuts manage cell navigation, data entry, formatting, formula editing, and sheet management for efficient spreadsheet work.
This reference covers 26 essential Google Sheets keyboard shortcuts organized across 5 categories: General, Navigation, Formatting, and more. Each shortcut lists both macOS and Windows/Linux key combinations where applicable, making it easy to find the right key combo regardless of your operating system.
Learning keyboard shortcuts is one of the highest-leverage investments you can make in your daily workflow. Studies show that developers and designers who rely on keyboard shortcuts are measurably faster at common tasks. Rather than memorizing every shortcut at once, focus on the ones you use most frequently and gradually expand your repertoire.
Bookmark this page for quick reference whenever you need to look up a Google Sheets shortcut. The categorized layout makes it easy to find shortcuts by their function, whether you need navigation, editing, or specialized commands.