After covering Google Docs shortcuts, and Chrome shortcuts, today's post features a collection of practical keyboard shortcuts for Google Sheets. I compiled these shortcuts from Sheets Help and I selected only those related to common actions on Sheets. The purpose is to help teachers and students make the best of Google Sheets in education. I invite you to check them out and use the infographic in class with your students.
1- Common actions
Select column : Ctrl + Space
Select row: Shift + Space
Paste values only: ⌘ + Shift + v
Insert new sheet: Shift + Fn + F11
Find and replace: ⌘ + Shift + h
2- Format cells
Insert link: ⌘ + k
Insert time: ⌘ + Shift + ;
Insert date: ⌘ + ;
Insert date and time: ⌘ + Option + Shift + ;
Format as decimal: Ctrl + Shift + 1
Format as time: Ctrl + Shift + 2
Format as date: Ctrl + Shift + 3
Format as currency: Ctrl + Shift + 4
Format as percentage: Ctrl + Shift + 5
Format as exponent: Ctrl + Shift + 6
Clear formatting: ⌘ + \
3- 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
Scroll to active cell: ⌘ + Backspace
Move to next sheet: Option + Down Arrow
Move to previous sheet: Option + Up Arrow
Open revision history: ⌘ + Option + Shift + h
4- Add or change rows and columns
Insert rows above: ⌘ + Option + = (with rows selected); Ctrl + Option + i, then r
Insert rows below: Ctrl + Option + i, then b
Insert columns to the left: ⌘ + Option + = (with columns selected); Ctrl + Option + i, then c
Insert columns to the right: Ctrl + Option + i, then o
Delete rows: ⌘ + Option + - (with rows selected); Ctrl + Option + e, then d
Delete columns: ⌘ + Option + - (with columns selected); Ctrl + Option + e, then e
Hide row: ⌘ + Option + 9
Unhide row: ⌘ + Shift + 9
Hide column: ⌘ + Option + 0
Unhide column: ⌘ + Shift + 0
Group rows or columns: Option + Shift + Right Arrow
Ungroup rows or columns: Option + Shift + Left Arrow
Expand grouped rows or columns: Option + Shift + Down Arrow
Collapse grouped rows or columns: Option + Shift + Up Arrow
5- Use formulas
Show all formulas: Ctrl + ~
Insert array formula: ⌘ + Shift + Enter
Collapse an expanded array formula: ⌘ + e
Absolute/relative references (when entering a formula): Fn + F4
Toggle formula result previews (when entering a formula): Fn + F9
Resize formula bar (move up or down): Ctrl + Option + Up and Ctrl + Option + Down
6- Help for screen readers
Turn on screen reader support: ⌘ + Option + z
Enable braille support: ⌘ + Option + h
Read column: ⌘ + Option + Shift + c
Read row: ⌘ + Option + Shift + r.