Google Sheets – Keyboard Shortcuts Cheat Sheet


Share

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.*

Gif titled Google Sheets – Keyboard Shortcuts Cheat Sheet - Spock

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!



Image titled Google Sheets Keyboard Shortcuts Cheat Sheet

Transcript of the Graphic “Google Sheets – Keyboard Shortcuts Cheat Sheet”

PC Shortcuts

COMMON ACTIONS

Open Ctrl + o
Find Ctrl + f
Undo Ctrl + z

NAVIGATE SPREADSHEET

Move to beginning of row Home
Move to beginning of sheet Ctrl + Home
Move to end of row End
Move to end of sheet Ctrl + End

EDIT NOTES AND COMMENTS

Insert/edit note Shift + F2
Insert/edit comment Ctrl + Alt + m

INSERT OR DELETE ROWS OR COLUMNS

Insert rows above Google Chrome: Alt + i, then r

Other browsers: Alt + Shift + i, then r

Insert rows below Google Chrome: Alt + i, then w

Other browsers: Alt + Shift + i, then w

Insert columns to the left Google Chrome: Alt + i, then c

Other browsers: Alt + Shift + i, then c

Insert columns to the right Google Chrome: Alt + i, then o

Other browsers: Alt + Shift + i, then o

Delete rows Google Chrome: Alt + e, then d

Other browsers: Alt + Shift + e, then d

Delete columns Google Chrome: Alt + e, then e

Other browsers: Alt + Shift + e, then e

USE FORMULAS

Show all formulas Ctrl + ‘

Mac Shortcuts

COMMON ACTIONS
Open ⌘ + o
Find ⌘ + f
Undo ⌘ + z
NAVIGATE SPREADSHEET
Move to beginning of row Fn + Left arrow
Move to beginning of sheet ⌘ + Fn + Left arrow
Move to end of row Fn + Right arrow
Move to end of sheet ⌘ + Fn + Right arrow
EDIT NOTES AND COMMENTS
Insert/edit note Shift + F2
Insert/edit comment ⌘ + Option + m
INSERT OR DELETE ROWS OR COLUMNS
Insert rows above Ctrl + Option + i, then r
Insert rows below Ctrl + Option + i, then b
Insert columns to the left Ctrl + Option + i, then c
Insert columns to the right Ctrl + Option + i, then o
Delete rows Ctrl + Option + e, then d
Delete columns Ctrl + Option + e, then e
USE FORMULAS
Show all formulas Ctrl + ‘
project management software, project management, collaboration software, project management tools, free project management software, online project management software, team collaboration software, project portfolio management, google sp, google project management, simple project management software, task management software, google docs keyboard shortcuts, google spreadsheets keyboard shortcuts, g suite keyboard shortcuts.

 

* As of 6/27/2017.

CHECK OUT THESE RELATED TIPS!