Google Sheets Keyboard Shortcuts Cheat Sheet (2026 Update)
Every click you can avoid adds up. This cheat sheet covers the Google Sheets shortcuts worth actually memorizing, organized by category so you can jump to what you need. Windows shortcuts are listed first in each row, with the Mac equivalent alongside; swap Ctrl for Cmd and Alt for Option in most cases.
Tip: You don't need to memorize this whole page. Press Ctrl + / (Windows) or Cmd + / (Mac) at any time inside Google Sheets to pull up the built-in shortcut panel.
| Action | Windows | Mac |
|---|---|---|
| Move to the edge of a data region | Ctrl + Arrow key | Cmd + Arrow key |
| Move to the beginning of a row | Home | Fn + Left Arrow |
| Move to cell A1 | Ctrl + Home | Cmd + Fn + Left Arrow |
| Move to the last cell with data | Ctrl + End | Cmd + Fn + Right Arrow |
| Move down one screen | Page Down | Fn + Down Arrow |
| Move up one screen | Page Up | Fn + Up Arrow |
| Go to a specific range or cell | Ctrl + Alt + Shift + J | Cmd + Option + Shift + J |
Selection
| Action | Windows | Mac |
|---|---|---|
| Select to the edge of a data region | Ctrl + Shift + Arrow key | Cmd + Shift + Arrow key |
| Select the entire row | Shift + Space | Shift + Space |
| Select the entire column | Ctrl + Space | Ctrl + Space |
| Select the whole sheet | Ctrl + A | Cmd + A |
| Extend selection by one cell | Shift + Arrow key | Shift + Arrow key |
| Select from active cell to A1 | Ctrl + Shift + Home | Cmd + Shift + Fn + Left Arrow |
Editing
| Action | Windows | Mac |
|---|---|---|
| Copy | Ctrl + C | Cmd + C |
| Cut | Ctrl + X | Cmd + X |
| Paste | Ctrl + V | Cmd + V |
| Paste values only | Ctrl + Shift + V | Cmd + Shift + V |
| Undo | Ctrl + Z | Cmd + Z |
| Redo | Ctrl + Y | Cmd + Y |
| Fill down (copy cell above) | Ctrl + D | Cmd + D |
| Fill right (copy cell to the left) | Ctrl + R | Cmd + R |
| Insert a line break within a cell | Alt + Enter | Option + Enter |
| Delete the selected content | Delete | Delete / Backspace |
| Insert current date | Ctrl + ; | Cmd + ; |
| Insert current time | Ctrl + Shift + ; | Cmd + Shift + ; |
| Find and replace | Ctrl + H | Cmd + Shift + H |
Formatting
| Action | Windows | Mac |
|---|---|---|
| Bold | Ctrl + B | Cmd + B |
| Italic | Ctrl + I | Cmd + I |
| Underline | Ctrl + U | Cmd + U |
| Strikethrough | Alt + Shift + 5 | Cmd + Shift + X |
| Clear formatting | Ctrl + \ | Cmd + \ |
| Apply borders | Alt + Shift + 7 | Option + Shift + 7 |
| Wrap text | via Format menu | via Format menu |
Formulas
| Action | Windows | Mac |
|---|---|---|
| Insert a new formula / start editing a cell | = (equals key) | = (equals key) |
| Show all formulas in the sheet | Ctrl + ` | Cmd + ` |
| Toggle absolute/relative references | F4 | Cmd + Y |
| Sum the selected range | Alt + = | Option + = |
| Insert a comment | Ctrl + Alt + M | Cmd + Option + M |
Rows, Columns, and Sheets
| Action | Windows | Mac |
|---|---|---|
| Insert row above | Ctrl + Alt + Shift + = (or right-click menu) | Cmd + Option + Shift + = |
| Delete selected row(s)/column(s) | Ctrl + Alt + Shift + Minus | Cmd + Option + Shift + Minus |
| Hide column | Ctrl + Alt + 0 | Cmd + Option + 0 |
| Move to next sheet | Ctrl + Shift + Page Down | Fn + Option + Shift + Down Arrow |
| Move to previous sheet | Ctrl + Shift + Page Up | Fn + Option + Shift + Up Arrow |
Data and Filters
| Action | Windows | Mac |
|---|---|---|
| Toggle filter on the current range | Ctrl + Shift + L | Cmd + Shift + L |
| Create a pivot table | Alt + D then P (or Insert menu) | via Insert menu |
| Open the tool finder / command search | Alt + / | Option + / |
Five Shortcuts to Start With
Trying to memorize all of these at once isn't realistic. If you only take away five, make it these; they cover the actions most people repeat dozens of times a day:
- Ctrl + D — fill down instead of dragging the cell handle
- Ctrl + Shift + V — paste values only, without carrying over formatting or formulas
- Ctrl + Arrow key — jump to the edge of a data block instead of scrolling
- Ctrl + Shift + Arrow key — select an entire data range in one move
- Ctrl + / — pull up the shortcut panel any time you forget one
 |
Using Ctrl+D to fill down a formula in Google Sheets |
Frequently Asked Questions
How do I see every shortcut without leaving Google Sheets?
Press Ctrl + / on Windows or Cmd + / on Mac. It opens an overlay listing every current shortcut, grouped by category, directly inside the spreadsheet.
Can I customize or remap Google Sheets shortcuts?
No, Google Sheets doesn't currently support creating custom shortcuts or remapping existing ones.
Do Excel shortcuts work in Google Sheets?
Many do, since Google Sheets supports "compatible spreadsheet shortcuts." You can turn this on from Help → Keyboard shortcuts, then enable the compatibility option at the bottom of that panel, which is useful if you're switching between Excel and Sheets regularly.
Have a shortcut you use constantly that isn't listed here? Drop it in the comments and I'll add it.
Post a Comment