Printable Google Sheets Keyboard Shortcuts
74 Google Sheets shortcuts on one page — navigation, formulas, formatting and data tools — with the Windows / Chrome OS keys and the Mac keys side by side, so one printout covers a mixed classroom or office. Hit Print or Download PDF; no signup. Copy, paste and undo work the same here as everywhere else, and live on the general keyboard shortcuts sheet instead.
Prints on one US Letter page. Set margins to "None" for the sharpest result.
Google Sheets Keyboard Shortcuts
74 shortcuts — Windows / Chrome OS and Mac keys side by side
Navigation & Selection
| Action | Windows / Chrome OS | Mac |
|---|---|---|
| Jump to the edge of data | Ctrl+Arrow | Cmd+Arrow |
| Select to the edge of data | Ctrl+Shift+Arrow | Cmd+Shift+Arrow |
| Select the whole column | Ctrl+Space | Ctrl+Space |
| Select the whole row | Shift+Space | Shift+Space |
| Select every cell | Ctrl+A | Cmd+A |
| Start of the row | Home | Fn+← |
| End of the row | End | Fn+→ |
| Back to cell A1 | Ctrl+Home | Cmd+Fn+← |
| End of the sheet | Ctrl+End | Cmd+Fn+→ |
| Scroll to the active cell | Ctrl+Backspace | Cmd+Backspace |
| Next sheet tab | Alt+↓ | Option+↓ |
| Previous sheet tab | Alt+↑ | Option+↑ |
| List all sheets | Alt+Shift+K | Option+Shift+K |
| Find | Ctrl+F | Cmd+F |
| Find and replace | Ctrl+H | Cmd+Shift+H |
| Open the link in a cell | Alt+Enter | Option+Enter |
| Show Google's full list | Ctrl+/ | Cmd+/ |
Formulas
| Action | Windows / Chrome OS | Mac |
|---|---|---|
| Show formulas, not results | Ctrl+~ | Ctrl+~ |
| Fill the formula down | Ctrl+D | Cmd+D |
| Fill the formula right | Ctrl+R | Cmd+R |
| Fill the selected range | Ctrl+Enter | Cmd+Enter |
| Cycle A1 → $A$1 → A$1 | F4 | Fn+F4 |
| Enter as an array formula | Ctrl+Shift+Enter | Cmd+Shift+Enter |
| Collapse an array formula | Ctrl+E | Cmd+E |
| Preview part of a formula | F9 | Fn+F9 |
| Show / hide formula help | Shift+F1 | Shift+Fn+F1 |
| Full / compact help box | F1 | Fn+F1 |
| Resize the formula bar | Ctrl+↑ / ↓ | Ctrl+Option+↑ / ↓ |
Menus
| Action | Windows / Chrome OS | Mac |
|---|---|---|
| File menu | Alt+F | Ctrl+Option+F |
| Edit menu | Alt+E | Ctrl+Option+E |
| View menu | Alt+V | Ctrl+Option+V |
| Insert menu | Alt+I | Ctrl+Option+I |
| Format menu | Alt+O | Ctrl+Option+O |
| Data menu | Alt+D | Ctrl+Option+D |
| Tools menu | Alt+T | Ctrl+Option+T |
| Sheet menu | Alt+Shift+S | Option+Shift+S |
| Right-click menu | Ctrl+Shift+\ | Cmd+Shift+\ |
Formatting
| Action | Windows / Chrome OS | Mac |
|---|---|---|
| Bold | Ctrl+B | Cmd+B |
| Italic | Ctrl+I | Cmd+I |
| Underline | Ctrl+U | Cmd+U |
| Strikethrough | Alt+Shift+5 | Cmd+Shift+X |
| Clear all formatting | Ctrl+\ | Cmd+\ |
| Align left | Ctrl+Shift+L | Cmd+Shift+L |
| Align center | Ctrl+Shift+E | Cmd+Shift+E |
| Align right | Ctrl+Shift+R | Cmd+Shift+R |
| Format as number | Ctrl+Shift+1 | Ctrl+Shift+1 |
| Format as time | Ctrl+Shift+2 | Ctrl+Shift+2 |
| Format as date | Ctrl+Shift+3 | Ctrl+Shift+3 |
| Format as currency | Ctrl+Shift+4 | Ctrl+Shift+4 |
| Format as percent | Ctrl+Shift+5 | Ctrl+Shift+5 |
| Format as exponent | Ctrl+Shift+6 | Ctrl+Shift+6 |
| Insert today's date | Ctrl+; | Cmd+; |
| Insert the current time | Ctrl+Shift+; | Cmd+Shift+; |
| Insert the date and time | Ctrl+Alt+Shift+; | Cmd+Option+Shift+; |
| Outer border on selection | Alt+Shift+7 | Option+Shift+7 |
| Remove all borders | Alt+Shift+6 | Option+Shift+6 |
| Insert a link | Ctrl+K | Cmd+K |
Data Tools
| Action | Windows / Chrome OS | Mac |
|---|---|---|
| Paste values only | Ctrl+Shift+V | Cmd+Shift+V |
| Insert rows / columns* | Ctrl+Alt+= | Cmd+Option+= |
| Delete rows / columns* | Ctrl+Alt+- | Cmd+Option+- |
| Hide the row | Ctrl+Alt+9 | Cmd+Option+9 |
| Unhide rows | Ctrl+Shift+9 | Cmd+Shift+9 |
| Hide the column | Ctrl+Alt+0 | Cmd+Option+0 |
| Unhide columns | Ctrl+Shift+0 | Cmd+Shift+0 |
| Group rows or columns | Alt+Shift+→ | Option+Shift+→ |
| Ungroup rows or columns | Alt+Shift+← | Option+Shift+← |
| Open a cell's filter menu | Ctrl+Alt+R | Ctrl+Cmd+R |
| Jump to the quick sum | Alt+Shift+Q | Option+Shift+Q |
| Insert a comment | Ctrl+Alt+M | Cmd+Option+M |
| Insert a note | Shift+F2 | Shift+F2 |
| Open version history | Ctrl+Alt+Shift+H | Cmd+Option+Shift+H |
| Add a new sheet | Shift+F11 | Shift+Fn+F11 |
| Search the menus | Alt+/ | Option+/ |
| Hide the menus | Ctrl+Shift+F | Ctrl+Shift+F |
* Select whole rows or columns first; new rows arrive above the selection and new columns to its left. Alt shortcuts assume Chrome — in Firefox and Safari add Shift (Alt + Shift + D opens the Data menu). On a Mac where the F-keys run brightness and volume, hold Fn as well. Press Ctrl + / (Cmd + /) in Sheets for Google's complete list. · printablepolly.com/google-sheets-shortcuts
The Shortcuts Worth Learning First
1. Ctrl + Arrow and Ctrl + Shift + Arrow
These two do more work than everything else on the chart. Ctrl + Arrow (Cmd + Arrow on a Mac) jumps to the last filled cell in that direction; adding Shift selects everything it passes. A thousand-row column gets selected in one keystroke instead of a scroll-and-drag, which is also how you find where a dataset actually ends.
2. F4 while you are writing a formula
With the cursor on a reference, F4 cycles A1 → $A$1 → A$1 → $A1. Locking the row or the column before you drag a formula down is the difference between a lookup that works on every row and one that quietly slides off its table.
3. Ctrl + Shift + V and Ctrl + Enter
Paste values only strips the source formatting and formulas, so a copied column arrives as plain numbers. Ctrl + Enter fills whatever you just typed into the entire selected range at once — handy for stamping a label or a formula across a filtered set of rows.
4. Ctrl + ~ when the numbers look wrong
Show all formulas swaps every result for the formula behind it, so a hard-coded number sitting in a column of calculations is obvious at a glance. Press it again to switch back. If the sheet is feeding a web page, the HTML & CSS reference covers the markup side, and the git cheat sheet covers getting it committed.
Printable PDF
The chart above is the whole thing — one US Letter page, black-and-white friendly, with both platforms in every row. Print as many copies as you need for a class, a team or a computer lab. No signup, no watermark.
More Printable Tech Cheat Sheets
Photoshop Shortcuts
97 shortcuts, Windows & Mac keys
⌨️Keyboard Shortcuts
Mac & Windows essentials
▤Excel Shortcuts
The same job, on the desktop
⌘Mac Keyboard Shortcuts
74 macOS shortcuts on one page
🌐HTML & CSS Reference
Tags, selectors, flexbox & grid
🔀Git Cheat Sheet
Everyday commands & workflows
📊Math Formulas
The formulas behind the numbers
FAQ
How do I see every Google Sheets keyboard shortcut inside Sheets?
Press Ctrl + / on Windows and Chrome OS, or Cmd + / on a Mac, and Google's own list opens over the spreadsheet. It is exhaustive, which also makes it hard to learn from — this chart is the working subset you actually reach for, printed on one page so it can sit next to the keyboard instead of covering the sheet you are editing.
Do Google Sheets shortcuts work the same as Excel's?
The everyday ones match: Ctrl + C, Ctrl + Z, Ctrl + ; for today's date, F4 for absolute references, and Ctrl + Shift + 1 through 6 for number formats behave the same way in both. The differences are in the menus and rows: Sheets inserts and deletes rows with Ctrl + Alt + = and Ctrl + Alt + -, and opens its menus with Alt + letter because it runs in a browser rather than in a desktop window.
Why does a shortcut do nothing in my browser?
The browser or the operating system claimed it first. The Alt + letter menu shortcuts assume Chrome — in Firefox and Safari the same menus need Alt + Shift + letter. On a Mac where the F-keys run brightness and volume, hold Fn as well (Fn + F4 for absolute references). Extensions that bind Ctrl + Shift combinations are the other common culprit.
What is the fastest way to move around a big spreadsheet?
Ctrl + Arrow (Cmd + Arrow on a Mac) jumps to the last filled cell in that direction, so one press lands you at the bottom of a 5,000-row column. Add Shift to select everything on the way — Ctrl + Shift + ↓ selects a whole column of data without touching the mouse. Ctrl + Backspace scrolls back to whatever cell is active when you get lost.
How do I lock a cell reference to $A$1?
Click the reference in the formula bar, or put the cursor next to it, and press F4 (Fn + F4 on a Mac). Each press cycles A1 to $A$1 to A$1 to $A1 and back, which is quicker than typing the dollar signs and is the shortcut most people are missing when a formula breaks as they drag it down.
Is this Google Sheets cheat sheet free to print?
Yes. Click Print or Download PDF and you get the whole chart on one US Letter page — no signup, no watermark, and no limit on copies for a classroom, a team, or a lab of machines.