app · Mac, Windows, Web
Google Sheets Keyboard Shortcuts
Google Sheets shortcuts are easiest to learn by task: navigation, editing, formatting, and view controls. Start with the table below, then use the menu path fallback when a key combination is blocked.
Reference table
Shortcut Library
Use this as the main reference: shortcut first, menu fallback second, and the note column for version or platform differences.
| Action | Mac | Windows / Web | Note |
|---|---|---|---|
| Show shortcuts | Command + / | Ctrl + / | Opens the built-in shortcut list. |
| Move to beginning of row | Home or Fn + Left | Home | Keyboard-dependent on Mac. |
| Move to beginning of sheet | Command + Home | Ctrl + Home | Browser and keyboard dependent. |
| Move to end of row | End or Fn + Right | End | Keyboard-dependent on Mac. |
| Move to end of sheet | Command + End | Ctrl + End | Browser and keyboard dependent. |
| Select column | Control + Space | Ctrl + Space | May conflict with system shortcut on Mac. |
| Select row | Shift + Space | Shift + Space | Selects current row. |
| Select all | Command + A | Ctrl + A | Press twice in some contexts. |
| Open find | Command + F | Ctrl + F | Browser find may appear first. |
| Find and replace | Command + Shift + H | Ctrl + H | Opens Sheets find and replace. |
| Fill down | Command + D | Ctrl + D | Copies the top cell down. |
| Fill right | Command + R | Ctrl + R | Copies left cell right. |
| Insert current date | Command + ; | Ctrl + ; | Static date value. |
| Insert current time | Command + Shift + ; | Ctrl + Shift + ; | Static time value. |
| Insert current date and time | Command + Option + Shift + ; | Ctrl + Alt + Shift + ; | Static timestamp. |
| Bold | Command + B | Ctrl + B | Text formatting. |
| Italic | Command + I | Ctrl + I | Text formatting. |
| Underline | Command + U | Ctrl + U | Text formatting. |
| Strikethrough | Option + Shift + 5 | Alt + Shift + 5 | May vary by browser. |
| Format as currency | Command + Shift + 4 | Ctrl + Shift + 4 | Applies currency format. |
| Format as percent | Command + Shift + 5 | Ctrl + Shift + 5 | Applies percent format. |
| Clear formatting | Command + \ | Ctrl + \ | Clears text and cell formatting. |
| Insert link | Command + K | Ctrl + K | Adds or edits hyperlink. |
| Insert comment | Command + Option + M | Ctrl + Alt + M | Adds comment to selected cell. |
| Open filter menu | Control + Command + R | Ctrl + Alt + R | Shortcut support can vary. |
| New sheet | Shift + F11 | Shift + F11 | Some keyboards require Fn. |
| Next sheet | Option + Down Arrow | Alt + Down Arrow | Browser conflicts possible. |
| Previous sheet | Option + Up Arrow | Alt + Up Arrow | Browser conflicts possible. |
| Open menus | Control + Option + F | Alt + / | Menu access depends on browser and OS. |
| Compact controls | Control + Shift + F | Ctrl + Shift + F | Hides or shows menus in Google editors. |
Menu Path Fallback
Open the app menu bar or command palette, then search for the action name shown in the table.
Compatibility
Google Sheets shortcuts can vary by operating system, app version, browser mode, and keyboard layout. Confirm platform-specific details before training a team or publishing an internal SOP.
If It Does Not Work
- Make sure the app or browser tab is focused before pressing the shortcut.
- Check whether a system shortcut, browser extension, or custom keyboard setting is intercepting the keys.
- Use the menu path as a fallback when the shortcut is unavailable on your platform.
FAQ
Why do shortcuts differ between Mac and Windows?
Modifier keys, app versions, browser focus, and keyboard layouts can change the exact shortcut.
What should I do if a shortcut does not work?
Check whether the app window is focused, confirm the platform, try the menu path, and look for system-level shortcut conflicts.
Are these pages a replacement for official docs?
No. They are practical reference pages with links to official sources where version-specific details should be checked.