Google Sheets guide

Google Sheets keyboard shortcuts

Google Sheets keyboard shortcuts reduce repeated mouse movements while you edit, format, navigate, and write formulas. This reference lists practical Mac and Windows or ChromeOS combinations from Google Docs Editors Help, with a smaller set chosen for everyday spreadsheet work.

Source: Keyboard shortcuts for Google Sheets, Google Docs Editors HelpLast verified Nov 5, 2026

Before you use the tables

Google notes that some shortcuts may not work for every language or keyboard. Browser and operating-system commands can also take priority over a spreadsheet shortcut. If a combination opens a browser action instead of changing the sheet, use the Sheets menu or press ⌘ + / on Mac or Ctrl + / on Windows and ChromeOS to find the in-product command.

Common actions

Action	Mac	Windows or ChromeOS
Undo	`⌘ + Z`	`Ctrl + Z`
Redo	`⌘ + Shift + Z`	`Ctrl + Shift + Z`
Copy	`⌘ + C`	`Ctrl + C`
Cut	`⌘ + X`	`Ctrl + X`
Paste	`⌘ + V`	`Ctrl + V`
Paste values only	`⌘ + Shift + V`	`Ctrl + Shift + V`
Find	`⌘ + F`	`Ctrl + F`
Show shortcut list	`⌘ + /`	`Ctrl + /`

Format cells

Action	Mac	Windows or ChromeOS
Bold	`⌘ + B`	`Ctrl + B`
Italic	`⌘ + I`	`Ctrl + I`
Underline	`⌘ + U`	`Ctrl + U`
Strikethrough	`⌘ + Shift + X`	`Alt + Shift + 5`
Insert link	`⌘ + K`	`Ctrl + K`
Clear formatting	`⌘ + \`	`Ctrl + \`
Format as currency	`Ctrl + Shift + 4`	`Ctrl + Shift + 4`
Format as percentage	`Ctrl + Shift + 5`	`Ctrl + Shift + 5`

Select and navigate

Action	Mac	Windows or ChromeOS
Select column	`Ctrl + Space`	`Ctrl + Space`
Select row	`Shift + Space`	`Shift + Space`
Select all	`⌘ + A`	`Ctrl + A`
Move to beginning of sheet	`⌘ + Fn + Left Arrow`	`Ctrl + Home`
Move to end of sheet	`⌘ + Fn + Right Arrow`	`Ctrl + End`
Move to next sheet	`Option + Down Arrow`	`Alt + Down Arrow`
Move to previous sheet	`Option + Up Arrow`	`Alt + Up Arrow`
Scroll to active cell	`⌘ + Backspace`	`Ctrl + Backspace`

Use formulas

Action	Mac	Windows or ChromeOS
Show all formulas	`Ctrl + ~`	`Ctrl + ~`
Insert array formula	`⌘ + Shift + Enter`	`Ctrl + Shift + Enter`
Show or hide formula help	`Shift + Fn + F1`	`Shift + F1`
Toggle absolute references	`Fn + F4`	`F4`
Toggle formula result previews	`Fn + F9`	`F9`
Toggle range-selection mode	`F2 or Ctrl + E`	`F2 or Ctrl + E`

Choose a small set first

Start with copy, paste, undo, redo, and the row or column selection shortcuts. Add formatting and formula shortcuts only when the matching action appears often in your work. A shortcut becomes useful through repetition, not through memorizing a long list once. Keep Google's full reference nearby for commands you use less often.