Google Sheets keyboard shortcuts
Google Sheets keyboard shortcuts
76 shortcuts
Browser
Google Sheets is the browser-based spreadsheet. Because it runs inside a browser it leans on Alt and Ctrl + Alt combinations where a desktop app would use a function key, and the Mac equivalents often use ⌥ + ⌘ rather than a plain ⌘. Google does not publish shortcuts for basic arrow-key cell movement, so those are deliberately absent here rather than invented.
Navigation
| Shortcut | What it does |
|---|---|
| Home | Move to the start of the row — On macOS: Fn + ← |
| End | Move to the end of the row — On macOS: Fn + → |
| Ctrl + Home | Move to the start of the sheet — On macOS: ⌘ + Fn + ← |
| Ctrl + End | Move to the end of the sheet — On macOS: ⌘ + Fn + → |
| Ctrl/⌘ + Backspace | Scroll back to the active cell |
| Alt + Down arrow | Go to the next sheet — On macOS: ⌥ + ↓, or ⌥ + → on a MacBook |
| Alt + Up arrow | Go to the previous sheet — On macOS: ⌥ + ↑, or ⌥ + ← on a MacBook |
| Alt + Shift + K | Show the list of sheets — On macOS: ⌥ + ⇧ + K |
| Alt + Enter | Open the link in the selected cell — On macOS: ⌥ + Return |
| Ctrl + Alt + Shift + I | Open the Explore panel — On macOS: ⌘ + ⌥ + ⇧ + I |
Selection and editing
| Shortcut | What it does |
|---|---|
| Ctrl + Space | Select the whole column — Still Ctrl on macOS — ⌘ + Space opens Spotlight |
| Shift + Space | Select the whole row |
| Ctrl/⌘ + A | Select every cell |
| Ctrl/⌘ + Z | Undo the last action |
| Ctrl/⌘ + Y | Redo the last action — Ctrl/⌘ + ⇧ + Z does the same |
| Ctrl/⌘ + F | Find in the sheet |
| Ctrl + H | Find and replace — On macOS: ⌘ + ⇧ + H |
| Ctrl/⌘ + Enter | Fill the selected range |
| Ctrl/⌘ + D | Fill down from the cell above |
| Ctrl/⌘ + R | Fill right from the cell to the left |
| Ctrl/⌘ + Shift + V | Paste values only |
| Ctrl/⌘ + \ | Clear the formatting from the selection |
Formatting
| Shortcut | What it does |
|---|---|
| Ctrl/⌘ + B | Apply or remove bold |
| Ctrl/⌘ + I | Apply or remove italic |
| Ctrl/⌘ + U | Apply or remove underline |
| Alt + Shift + 5 | Apply or remove strikethrough — On macOS: ⌘ + ⇧ + X |
| Ctrl/⌘ + Shift + E | Centre-align the selection |
| Ctrl/⌘ + Shift + L | Left-align the selection |
| Ctrl/⌘ + Shift + R | Right-align the selection |
| Alt + Shift + 1 | Apply a top border — On macOS: ⌥ + ⇧ + 1 |
| Alt + Shift + 7 | Apply an outer border — On macOS: ⌥ + ⇧ + 7 |
| Alt + Shift + 6 | Remove every border — On macOS: ⌥ + ⇧ + 6 |
| Ctrl/⌘ + K | Insert a link |
| Ctrl + ; | Insert the current date — On macOS: ⌘ + ; |
| Ctrl + Shift + ; | Insert the current time — On macOS: ⌘ + ⇧ + ; |
| Ctrl + Shift + 4 | Format the selection as currency — Still Control on macOS, not ⌘ |
Formulas
| Shortcut | What it does |
|---|---|
| Ctrl + ~ | Show formulas instead of results — Still Control on macOS, not ⌘ |
| Ctrl/⌘ + Shift + Enter | Enter the formula as an array formula |
| Ctrl/⌘ + E | Collapse an expanded array formula |
| F4 | Cycle absolute and relative references — On macOS: Fn + F4 |
| F9 | Toggle previews of formula results — On macOS: Fn + F9 |
| F1 | Switch between full and compact formula help — On macOS: Fn + F1 |
| Shift + F1 | Show or hide formula help while typing — On macOS: ⇧ + Fn + F1 |
| Ctrl + Up arrow | Resize the formula bar — On macOS: ⌃ + ⌥ + ↑ |
Rows, columns and sheets
| Shortcut | What it does |
|---|---|
| Ctrl + Alt + = | Insert rows or columns, matching whatever is selected — On macOS: ⌘ + ⌥ + = |
| Ctrl + Alt + - | Delete the selected rows or columns — On macOS: ⌘ + ⌥ + - |
| Ctrl + Alt + 9 | Hide the selected row — On macOS: ⌘ + ⌥ + 9 |
| Ctrl/⌘ + Shift + 9 | Unhide a hidden row |
| Ctrl + Alt + 0 | Hide the selected column — On macOS: ⌘ + ⌥ + 0 |
| Ctrl/⌘ + Shift + 0 | Unhide a hidden column |
| Alt + Shift + Right arrow | Group the selected rows or columns — On macOS: ⌥ + ⇧ + → |
| Alt + Shift + Left arrow | Ungroup the selected rows or columns — On macOS: ⌥ + ⇧ + ← |
| Ctrl + Alt + T | Convert the range to a table — On macOS: ⌘ + ⌥ + T |
Comments and collaboration
| Shortcut | What it does |
|---|---|
| Shift + F2 | Insert or edit a note |
| Ctrl + Alt + M | Insert or edit a comment — On macOS: ⌘ + ⌥ + M |
| Ctrl + Alt + Shift + A | Open the comment thread — On macOS: ⌘ + ⌥ + ⇧ + A |
| R | Reply to the current comment |
| J | Move to the next comment |
| K | Move to the previous comment |
| E | Resolve the current comment |
| U | Leave the current comment |
| Ctrl + Alt + Shift + H | Open the version history — On macOS: ⌘ + ⌥ + ⇧ + H |
Menus
| Shortcut | What it does |
|---|---|
| Alt + F | Open the File menu — Alt + ⇧ + F outside Chrome; on macOS: ⌃ + ⌥ + F |
| Alt + E | Open the Edit menu — Alt + ⇧ + E outside Chrome; on macOS: ⌃ + ⌥ + E |
| Alt + I | Open the Insert menu — Alt + ⇧ + I outside Chrome; on macOS: ⌃ + ⌥ + I |
| Alt + O | Open the Format menu — Alt + ⇧ + O outside Chrome; on macOS: ⌃ + ⌥ + O |
| Ctrl + Shift + \ | Open the right-click context menu — On macOS: ⌘ + ⇧ + \ |
| Ctrl + Alt + \ | Open the table column menu — On macOS: ⌘ + ⌥ + \ |
View and tools
| Shortcut | What it does |
|---|---|
| Ctrl/⌘ + / | Show the common shortcuts overlay |
| Alt + / | Open the tool finder to search the menus — On macOS: ⌥ + / |
| Ctrl + Shift + F | Toggle compact controls — Still Control on macOS, not ⌘ |
| Ctrl/⌘ + Shift + K | Turn input tools on or off |
| Ctrl + Alt + Shift + K | Choose an input tool — On macOS: ⌘ + ⌥ + ⇧ + K |
| Ctrl + Alt + Z | Turn on screen reader support — On macOS: ⌘ + ⌥ + Z |
| Ctrl + Alt + H | Turn on braille support — On macOS: ⌘ + ⌥ + H |
| Ctrl + Alt + Shift + C | Read the current column aloud — On macOS: ⌘ + ⌥ + ⇧ + C |
Common questions
- How many keyboard shortcuts does Google Sheets have?
- This page lists 76 shortcuts across 8 groups, covering the ones people actually use day to day rather than every binding the application defines.
Related pages
Sources
- Official vendor product documentation — At One Place