This article is republished from the original at support.google.com
Shortcut Matters
Operating System: Windows
With the Frequently Used shortcuts for Google Sheets provided here, you will not have to be a brainbox of keyboard shortcuts to use them. You will only use the popular ones to get your tasks done without much stress. If you are just starting out with keyboard shortcuts, it is advised you start with these few. You can check the full list if the shortcut you seek is not found among these ones.
This table lists the most frequently used shortcuts in Sheets.
| Task Shortcut | |
|---|---|
| Select column | Ctrl + Space |
| Select row | Shift + Space |
| Select all | Ctrl + a Ctrl + Shift + Space |
| Undo | Ctrl + z |
| Redo | Ctrl + y Ctrl + Shift + z F4 |
| Find | Ctrl + f |
| Find and replace | Ctrl + h |
| Fill range | Ctrl + Enter |
| Fill down | Ctrl + d |
| Fill right | Ctrl + r |
| Save (every change is saved automatically in Drive) | Ctrl + s |
| Open | Ctrl + o |
| Ctrl + p | |
| Copy | Ctrl + c |
| Cut | Ctrl + x |
| Paste | Ctrl + v |
| Paste values only | Ctrl + Shift + v |
| Show common keyboard shortcuts | Ctrl + / |
| Insert new sheet | Shift + F11 |
| Compact controls | Ctrl + Shift + f |
| Input tools on/off (available in spreadsheets in non-Latin languages) | Ctrl + Shift + k |
| Select input tools | Ctrl + Alt + Shift + k |
| Tool finder (formerly Search the menus) | Alt + / |
| Rename sheet | Alt + 1 |
If you want more Google Sheets key combinations, go to the COMPLETE LIST.
We have made our books available on the different Amazon stores to make your shopping them more convenient. If you are in Africa or find it difficult to make purchases through Amazon, go to Selar or our website. Grab a copy today and remember to leave your review.
