Free · Printable · Save as PDF
Google Sheets shortcuts cheat sheet (printable)
60 common shortcuts on one A4 page, split into Windows and Mac. Print this page as it is, or download the PDF.
Choose the keys to print
Pick Windows or Mac in the tabs below, then print.
One A4 page · Free · No sign-up
Download the cheat sheet as PDF
A PDF that fits on one A4 page. Best if you want to print it and keep it on your desk.
You can also print straight from the screen. Use this PDF if you want it on a single page.
Google Sheets shortcuts cheat sheet (Windows)
| Action | Keys |
|---|---|
| Navigation | |
| Jump to the edge of the data | Ctrl + Arrow |
| Go to the top of the sheet | Ctrl + Home |
| Go to the last cell with data | Ctrl + End |
| Go to the next sheet | Alt + ↓ |
| Go to the previous sheet | Alt + ↑ |
| Find | Ctrl + F |
| Find and replace | Ctrl + H |
| Selection | |
| Select the entire row | Shift + Space |
| Select the entire column | Ctrl + Space |
| Select all | Ctrl + A |
| Select to the edge of the data | Ctrl + Shift + Arrow |
| Entering and editing | |
| Edit the cell | F2 |
| Fill down | Ctrl + D |
| Fill right | Ctrl + R |
| Copy to range | Ctrl + Enter |
| Insert today's date | Ctrl + ; |
| Insert the current time | Ctrl + Shift + ; |
| Insert date and time | Ctrl + Alt + Shift + ; |
| Undo | Ctrl + Z |
| Redo | Ctrl + Y |
| Toggle absolute and relative references | F4 |
| Show all formulas | Ctrl + ~ |
| Copy and paste | |
| Copy | Ctrl + C |
| Cut | Ctrl + X |
| Paste | Ctrl + V |
| Paste values only | Ctrl + Shift + V |
| Paste format only | Ctrl + Alt + V |
| Formatting and number formats | |
| Bold | Ctrl + B |
| Italic | Ctrl + I |
| Action | Keys |
|---|---|
| Underline | Ctrl + U |
| Strikethrough | Alt + Shift + 5 |
| Clear formatting | Ctrl + \ |
| Center align | Ctrl + Shift + E |
| Left align | Ctrl + Shift + L |
| Right align | Ctrl + Shift + R |
| Number format | Ctrl + Shift + 1 |
| Time format | Ctrl + Shift + 2 |
| Date format | Ctrl + Shift + 3 |
| Currency format | Ctrl + Shift + 4 |
| Percent format | Ctrl + Shift + 5 |
| Scientific format | Ctrl + Shift + 6 |
| Outer border | Alt + Shift + 7 |
| Clear borders | Alt + Shift + 6 |
| Rows and columns | |
| Insert row | Ctrl + Alt + = |
| Delete row | Ctrl + Alt + - |
| Hide rows | Ctrl + Alt + 9 |
| Unhide rows | Ctrl + Shift + 9 |
| Hide columns | Ctrl + Alt + 0 |
| Unhide columns | Ctrl + Shift + 0 |
| Group rows or columns | Alt + Shift + → |
| Ungroup | Alt + Shift + ← |
| Convert to table | Ctrl + Alt + T |
| Notes, comments and links | |
| Insert or edit a note | Shift + F2 |
| Insert a comment | Ctrl + Alt + M |
| Insert a link | Ctrl + K |
| Open a link | Alt + Enter |
| Open version history | Ctrl + Alt + Shift + H |
| Menus and sheets | |
| Search the menus | Alt + / |
| Show the shortcut list | Ctrl + / |
| Insert a new sheet | Shift + F11 |
Google Sheets shortcuts cheat sheet (Mac)
| Action | Keys |
|---|---|
| Navigation | |
| Jump to the edge of the data | ⌘ + Arrow |
| Go to the top of the sheet | ⌘ + fn + ← |
| Go to the last cell with data | ⌘ + fn + → |
| Go to the next sheet | Option + ↓ |
| Go to the previous sheet | Option + ↑ |
| Find | ⌘ + F |
| Find and replace | ⌘ + Shift + H |
| Selection | |
| Select the entire row | Shift + Space |
| Select the entire column | control + Space |
| Select all | ⌘ + A |
| Select to the edge of the data | ⌘ + Shift + Arrow |
| Entering and editing | |
| Edit the cell | F2 |
| Fill down | ⌘ + D |
| Fill right | ⌘ + R |
| Copy to range | ⌘ + Return |
| Insert today's date | ⌘ + ; |
| Insert the current time | ⌘ + Shift + ; |
| Insert date and time | ⌘ + Option + Shift + ; |
| Undo | ⌘ + Z |
| Redo | ⌘ + Y |
| Toggle absolute and relative references | fn + F4 |
| Show all formulas | control + ~ |
| Copy and paste | |
| Copy | ⌘ + C |
| Cut | ⌘ + X |
| Paste | ⌘ + V |
| Paste values only | ⌘ + Shift + V |
| Paste format only | ⌘ + Option + V |
| Formatting and number formats | |
| Bold | ⌘ + B |
| Italic | ⌘ + I |
| Action | Keys |
|---|---|
| Underline | ⌘ + U |
| Strikethrough | ⌘ + Shift + X |
| Clear formatting | ⌘ + \ |
| Center align | ⌘ + Shift + E |
| Left align | ⌘ + Shift + L |
| Right align | ⌘ + Shift + R |
| Number format | control + Shift + 1 |
| Time format | control + Shift + 2 |
| Date format | control + Shift + 3 |
| Currency format | control + Shift + 4 |
| Percent format | control + Shift + 5 |
| Scientific format | control + Shift + 6 |
| Outer border | Option + Shift + 7 |
| Clear borders | Option + Shift + 6 |
| Rows and columns | |
| Insert row | ⌘ + Option + = |
| Delete row | ⌘ + Option + - |
| Hide rows | ⌘ + Option + 9 |
| Unhide rows | ⌘ + Shift + 9 |
| Hide columns | ⌘ + Option + 0 |
| Unhide columns | ⌘ + Shift + 0 |
| Group rows or columns | Option + Shift + → |
| Ungroup | Option + Shift + ← |
| Convert to table | ⌘ + Option + T |
| Notes, comments and links | |
| Insert or edit a note | Shift + F2 |
| Insert a comment | ⌘ + Option + M |
| Insert a link | ⌘ + K |
| Open a link | Option + Return |
| Open version history | ⌘ + Option + Shift + H |
| Menus and sheets | |
| Search the menus | Option + / |
| Show the shortcut list | ⌘ + / |
| Insert a new sheet | Shift + F11 |
* Google Sheets is a trademark of Google LLC. This site is not affiliated with Google.
SIMULATION
Try the keys from the sheet in a virtual spreadsheet
A simulation where you finish an office supply order sheet with the keyboard only, no mouse. 6 chapters, 24 missions.