When you work your fingers to the bone on the best Google Sheet risk register, having to move them like a pendulum to get to the mouse is an agony.
What if you could keep your fingertips on the PC or Mac piano for most of the time, instead?
Google Sheets helps you with a great list of keyboard shortcuts.
107.
107 keyboard shortcuts.
107 Google Sheets keyboard shortcuts.*
For you and me, 100% Human DNA, I’ve created this graphic of the 16 most handy Google Sheets keyboard shortcuts.
Simply bookmark it and share it with your team members to ease your first date with such an overwhelming help.
From pushing the mouse around to getting work done!
Google Sheets – 16 Keyboard Shortcuts You Need to Remember
A quick and easy reference to the most important keyboard shortcuts on Google Sheets.
Common actions | PC | Mac |
Open | Ctrl + o | ⌘ + o |
Find | Ctrl + f | ⌘ + f |
Undo | Ctrl + z | ⌘ + z |
Navigate spreadsheet | PC | Mac |
Move to beginning of row | Home | Fn + Left arrow |
Move to beginning of sheet | Ctrl + Home | ⌘ + Fn + Left arrow |
Move to end of row | End | Fn + Right arrow |
Move to end of sheet | Ctrl + End | ⌘ + Fn + Right arrow |
Edit notes and comments | PC | Mac |
Insert/edit note | Shift + F2 | Shift + F2 |
Insert/edit comment | Ctrl + Alt + m | ⌘ + Option + m |
Insert or delete rows or columns | PC | Mac |
Insert rows above | Google Chrome: Alt + i, then r Other browsers: Alt + Shift + i, then r | Ctrl + Option + i, then r |
Insert rows below | Google Chrome: Alt + i, then w Other browsers: Alt + Shift + i, then w | Ctrl + Option + i, then b |
Insert columns to the left | Google Chrome: Alt + i, then c Other browsers: Alt + Shift + i, then c | Ctrl + Option + i, then c |
Insert columns to the right | Google Chrome: Alt + i, then o Other browsers: Alt + Shift + i, then o | Ctrl + Option + i, then o |
Delete rows | Google Chrome: Alt + e, then d Google Chrome: Alt + e, then d Other browsers: Alt + Shift + e, then d | Ctrl + Option + e, then d |
Delete columns | Google Chrome: Alt + e, then e Google Chrome: Alt + e, then e Other browsers: Alt + Shift + e, then e | Ctrl + Option + e, then e |
Use formulas | PC | Mac |
Show all formulas | Ctrl + ‘ | Ctrl + ‘ |