Google Sheets shortcuts
- 32 shortcuts
- 5 sections
- Productivity
- Verified against official docs
Your answer helps keep this page right.
Do these shortcuts work for you?
In Google Sheets, Jump To Bottom Of Data and the other "jump to" shortcuts move to the edge of the current block of data. Format Currency, Format Percent and Format Date change a number format in one step, without opening a menu.
Start with these
- Edit Cell
- Fill Down
- Jump To Bottom Of Data
- Format Currency
- Insert Row Or Column
- Find And Replace
Tips for Google Sheets
- Fill Down ⌘D copies the top cell of the selection into every cell below it.
- New Line In Cell ⌥↩ starts a new line inside the cell instead of moving to the next row.
- Insert Note ⇧F2 adds a note to a cell. Unlike comments, notes don’t notify anyone.
Cell editing8
| Action | Shortcut |
|---|---|
| Edit Cell | |
| Confirm Entry | |
| Cancel Entry | |
| Move To Next Cell | |
| Move Up | |
| New Line In Cell | |
| Fill Down | |
| Fill Right |
Formatting12
| Action | Shortcut |
|---|---|
| Bold | |
| Italic | |
| Underline | |
| Strikethrough | |
| Clear Formatting | |
| Align Center | |
| Align Left | |
| Align Right | |
| Format Decimal | |
| Format Date | |
| Format Currency | |
| Format Percent |
Rows and columns4
| Action | Shortcut |
|---|---|
| Insert Row Or Column | |
| Delete Row Or Column | |
| Hide Row | |
| Hide Column |
Notes and comments2
| Action | Shortcut |
|---|---|
| Insert Comment | |
| Insert Note |
Report a problem
GitHub is public. Email is private.
More Productivity shortcuts
Explore more macOS apps
Frequently Asked Questions
How many keyboard shortcuts does Google Sheets have on macOS?
Google Sheets has 32 keyboard shortcuts on macOS, organized into 5 sections: Cell editing, Formatting, Navigation, Rows and columns, and more. This page lists all of them with searchable, organized shortcut tables.
Which Google Sheets shortcuts should I learn first?
Start with Edit Cell (F2), Fill Down (⌘D), Jump To Bottom Of Data (⌘↓), Format Currency (⇧⌘4), Insert Row Or Column (⌥⌘=), Find And Replace (⌘H). The sections on this page list the rest.
Can I download Google Sheets shortcuts as a PDF?
Yes. Click the download button at the top of this page to generate a printable PDF cheat sheet with all 32 Google Sheets shortcuts. The PDF includes organized sections, keycap-style key labels, and space for your own notes.
Where is the official Google Sheets keyboard shortcuts documentation?
The official Google Sheets keyboard shortcuts documentation is available on their website. Every shortcut on this page is sourced from and verified against the official documentation to ensure accuracy.
Do these Google Sheets shortcuts work on all Mac keyboards?
Yes. These shortcuts work on all Mac keyboards, including MacBook built-in keyboards and external Apple keyboards. The modifier keys are Command (⌘), Option (⌥), Control (⌃), and Shift (⇧). On keyboards without a Function row, some F-key shortcuts may require holding the Fn key.
Maintained by Vladik Didyk
Access Google Sheets shortcuts from your menu bar
KeyShortcut detects the active app and shows its shortcuts instantly. Switch it on in Settings. No memorization needed.