Knowing the right Google Sheets keyboard shortcuts can cut your spreadsheet work in half. Whether you are navigating massive datasets, formatting reports, or building formulas, shortcuts keep your hands on the keyboard and your workflow moving. This cheat sheet covers 50+ essential shortcuts for both Windows and Mac so you can stop clicking through menus and start working faster.
Key Takeaways:50+ Google Sheets keyboard shortcuts organized by category for quick referenceShortcuts can reduce repetitive spreadsheet tasks by up to 30%Mac users swap Ctrl for Cmd and Alt for Option in most shortcutsPair shortcuts with SmoothSheet for even faster large-data workflows
Navigation Shortcuts
Navigation shortcuts help you move through large spreadsheets without reaching for the mouse. Once you memorize a few of these, scrolling through thousands of rows becomes effortless — especially useful when you freeze rows in Google Sheets and need to jump between header and data sections.
| Action | Windows | Mac |
|---|---|---|
| Move one cell up / down / left / right | Arrow keys | Arrow keys |
| Jump to edge of data region | Ctrl + Arrow key | Cmd + Arrow key |
| Move to beginning of row | Home | Fn + Left Arrow |
| Move to cell A1 | Ctrl + Home | Cmd + Fn + Left Arrow |
| Move to last cell with data | Ctrl + End | Cmd + Fn + Right Arrow |
| Go to a specific cell | Ctrl + G or F5 | Cmd + G or Fn + F5 |
| Move to next sheet tab | Ctrl + Page Down | Cmd + Shift + Fn + Down Arrow |
| Move to previous sheet tab | Ctrl + Page Up | Cmd + Shift + Fn + Up Arrow |
| Scroll down one screen | Page Down | Fn + Down Arrow |
| Scroll up one screen | Page Up | Fn + Up Arrow |
Selection Shortcuts
Selecting cells efficiently is the foundation of fast editing. These shortcuts let you highlight rows, columns, and entire ranges without dragging your mouse across the screen.
| Action | Windows | Mac |
|---|---|---|
| Select entire row | Shift + Space | Shift + Space |
| Select entire column | Ctrl + Space | Ctrl + Space |
| Select all cells | Ctrl + A | Cmd + A |
| Extend selection by one cell | Shift + Arrow key | Shift + Arrow key |
| Extend selection to edge of data | Ctrl + Shift + Arrow key | Cmd + Shift + Arrow key |
| Extend selection to beginning of row | Shift + Home | Shift + Fn + Left Arrow |
| Select from current cell to start of sheet | Ctrl + Shift + Home | Cmd + Shift + Fn + Left Arrow |
Editing Shortcuts
Editing shortcuts handle the most common actions: copying, pasting, undoing mistakes, and managing rows and columns. The paste-values-only shortcut alone can save you hours of reformatting when you work with data from external sources.
| 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 |
| Find | Ctrl + F | Cmd + F |
| Find and replace | Ctrl + H | Cmd + Shift + H |
| Edit active cell (enter edit mode) | F2 | F2 |
| Insert row above | Ctrl + Shift + = (select row first) | Cmd + Shift + = (select row first) |
| Delete row | Ctrl + - (select row first) | Cmd + - (select row first) |
| Insert column left | Ctrl + Shift + = (select column first) | Cmd + Shift + = (select column first) |
| Delete column | Ctrl + - (select column first) | Cmd + - (select column first) |
| Clear cell content | Delete | Delete |
| Fill down (copy cell above) | Ctrl + D | Cmd + D |
| Fill right (copy cell to the left) | Ctrl + R | Cmd + R |
Pro tip: When you import large CSV files into Google Sheets using SmoothSheet, the paste-values-only shortcut (Ctrl + Shift + V) is great for quickly moving processed data between sheets without carrying over formatting artifacts.
Formatting Shortcuts
Formatting shortcuts let you style cells instantly. Instead of navigating the toolbar for bold, borders, or number formats, use these keys to keep your flow uninterrupted — this is especially handy when setting up conditional formatting rules.
| 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 |
| Align center | Ctrl + Shift + E | Cmd + Shift + E |
| Align left | Ctrl + Shift + L | Cmd + Shift + L |
| Align right | Ctrl + Shift + R | Cmd + Shift + R |
| Apply border (top) | Alt + Shift + 1 | Cmd + Option + 1 |
| Apply border (right) | Alt + Shift + 2 | Cmd + Option + 2 |
| Apply border (bottom) | Alt + Shift + 3 | Cmd + Option + 3 |
| Apply border (left) | Alt + Shift + 4 | Cmd + Option + 4 |
| Remove borders | Alt + Shift + 6 | Cmd + Option + 6 |
| Apply outer border | Alt + Shift + 7 | Cmd + Option + 7 |
| Format as currency | Ctrl + Shift + 4 | Cmd + Shift + 4 |
| Format as percentage | Ctrl + Shift + 5 | Cmd + Shift + 5 |
| Format as date | Ctrl + Shift + 3 | Cmd + Shift + 3 |
| Format as time | Ctrl + Shift + 2 | Cmd + Shift + 2 |
| Format as decimal | Ctrl + Shift + 1 | Cmd + Shift + 1 |
| Clear formatting | Ctrl + \ | Cmd + \ |
Formula Shortcuts
If you build formulas regularly, these shortcuts save serious time. The absolute-reference toggle (F4) alone prevents countless errors when copying formulas across ranges.
| Action | Windows | Mac |
|---|---|---|
| Toggle absolute / relative reference ($) | F4 | F4 |
| Show all formulas in sheet | Ctrl + ` | Cmd + ` |
| Insert function | Shift + F3 | Shift + Fn + F3 |
| Accept autocomplete suggestion | Tab | Tab |
| Enter formula in cell and stay in cell | Ctrl + Enter | Cmd + Enter |
| Enter formula and move down | Enter | Enter |
| Cancel formula entry | Escape | Escape |
| Insert array formula | Ctrl + Shift + Enter | Cmd + Shift + Enter |
If you want to see formulas in action, check out our guide on the Google Sheets QUERY function — it is one of the most powerful functions you can pair with these shortcuts.
Advanced Shortcuts
These less-known shortcuts are for power users who want to squeeze every bit of efficiency out of Google Sheets. From inserting comments to toggling filters, these will set you apart.
| Action | Windows | Mac |
|---|---|---|
| Insert note | Shift + F2 | Shift + F2 |
| Insert comment | Ctrl + Alt + M | Cmd + Option + M |
| Open Explore panel | Ctrl + Alt + Shift + I | Cmd + Option + Shift + I |
| Toggle filter | Ctrl + Shift + L (with data selected) | Cmd + Shift + L (with data selected) |
| Group rows or columns | Alt + Shift + Right Arrow | Option + Shift + Right Arrow |
| Ungroup rows or columns | Alt + Shift + Left Arrow | Option + Shift + Left Arrow |
| Hide row | Ctrl + Alt + 9 | Cmd + Option + 9 |
| Unhide row | Ctrl + Shift + 9 | Cmd + Shift + 9 |
| Hide column | Ctrl + Alt + 0 | Cmd + Option + 0 |
| Unhide column | Ctrl + Shift + 0 | Cmd + Shift + 0 |
| Insert link | Ctrl + K | Cmd + K |
| Open keyboard shortcuts help | Ctrl + / | Cmd + / |
Mac vs Windows: Key Differences
If you switch between Mac and Windows, here is the quick translation table. Memorize these four mappings and you can convert any Windows shortcut to Mac on the fly.
| Windows Key | Mac Equivalent | Example |
|---|---|---|
| Ctrl | Cmd (⌘) | Ctrl + C → Cmd + C |
| Alt | Option (⌥) | Alt + Shift + 5 → Cmd + Shift + X |
| Home | Fn + Left Arrow | Home → Fn + Left Arrow |
| End | Fn + Right Arrow | End → Fn + Right Arrow |
| Page Down | Fn + Down Arrow | Page Down → Fn + Down Arrow |
| Page Up | Fn + Up Arrow | Page Up → Fn + Up Arrow |
Note: Some shortcuts differ beyond a simple key swap. Strikethrough, for example, is Alt + Shift + 5 on Windows but Cmd + Shift + X on Mac. When in doubt, press Ctrl + / (Windows) or Cmd + / (Mac) inside Google Sheets to open the built-in shortcut reference panel.
Tips for Learning Shortcuts Faster
Memorizing 50+ shortcuts at once is unrealistic. Here is a practical approach:
- Start with five. Pick the five shortcuts you would use most (copy, paste, paste values, undo, and jump to edge) and commit to using them for a week.
- Add five more each week. Once the first set is muscle memory, layer on navigation and selection shortcuts.
- Print or bookmark this page. Keep it open in a tab until the shortcuts become second nature.
- Use the built-in help. Press Ctrl + / (or Cmd + / on Mac) to see Google Sheets' own shortcut overlay any time you forget.
For a complete list of every shortcut Google Sheets supports, see the official Google Sheets keyboard shortcuts reference.
FAQ
How do I see all keyboard shortcuts in Google Sheets?
Press Ctrl + / on Windows or Cmd + / on Mac. This opens the built-in keyboard shortcuts panel that lists every available shortcut organized by category.
Does Google Sheets support custom keyboard shortcuts?
No, Google Sheets does not currently allow users to create or remap custom keyboard shortcuts. You can use browser extensions or OS-level tools like AutoHotkey (Windows) or Keyboard Maestro (Mac) to create custom macros, but native customization is not available.
What is the shortcut to paste values only in Google Sheets?
Use Ctrl + Shift + V on Windows or Cmd + Shift + V on Mac. This pastes only the raw values without any formatting or formulas, which is useful when cleaning data or importing values from external sources.
Are Google Sheets shortcuts the same as Excel shortcuts?
Many core shortcuts overlap — copy, paste, bold, and undo work identically. However, Google Sheets has unique shortcuts for its web-based features like the Explore panel (Ctrl + Alt + Shift + I) and inserting comments (Ctrl + Alt + M). Some Excel-specific shortcuts like Alt key menu navigation do not exist in Sheets. For detailed differences, check our Google Sheets vs Excel comparison.
Conclusion
Google Sheets keyboard shortcuts are one of the simplest ways to speed up your spreadsheet workflow. Start with the basics — copy, paste values, undo, and navigation — then build up to formatting and formula shortcuts as they become second nature. Bookmark this cheat sheet and come back to it whenever you need a refresher.
And when your data gets too large for manual workflows, check out how you can validate your CSV structure with our free CSV Analyzer before importing, or set up data validation rules to keep your sheets clean from the start.