Print-friendly
keyboard shortcuts
for all your favorite Mac apps

Google Sheets

General

Select column
Select row
A
Select all
Hide background over selected cells
Z
Undo
Y
Redo
F
find
H
Find and replace
Fill range
D
Fill down
R
Fill right
S
Save
O
Open
P
Print
C
Copy
X
Cut
V
Paste
V
Paste values only
/
Show common keyboard shortcuts
K
Compact controls
K
Input tools on/off
K
Select input tools

Cell Formatting

B
Bolds
U
Underline
I
Italicize
5
Strikethrough
E
Center align
L
Left align
R
Right align
1
Apply top border
2
Apply right border
3
Apply bottom border
4
Apply left border
6
Remove borders
7
Apply outer border
K
Insert link
;
Insert name
;
Insert date
1
Format as decimal
2
Format as time
3
Format as date
4
Format as currency
5
Format as percentage
6
Format as exponent
\\
Clear formatting

Insert or Delete Rows or Columns

I
then
R
Insert row above
I
then
W
Insert row below
I
then
C
Insert column to the left
I
then
G
Insert column to the right
E
then
D
Delete row
E
then
E
Delete column

Spreadsheet Navigation

Fn
Move to beginning of row
Fn
Move to beginning of sheet
Fn
Move to end of row
Fn
Move to end of sheet
Scroll to active cell
Fn
Move to next sheet
Fn
Move to previous sheet
K
Display list of sheets
Open hyperlink
M
Move focus out of spreadsheet
Q
Move to quicksum
hold
press
E
then
P
Move focus to popup
R
Open drop-down menu on filtered cell
G
Open revision history
Open chat inside the spreadsheet
Close drawing editor

Notes and Comments

F2
Insert/edit note
M
Insert/edit comment
A
Open comment discussion thread
hold
press
E
then
C
Enter current comment
hold
press
N
then
C
Move to next comment
hold
press
P
then
C
Move to previous comment

Menus

F
File menu
E
Edit menu
V
View menu
I
Insert menu
O
Format menu
D
Data menu
T
Tools menu
M
Form menu
N
Add-ons menu
H
Help menu
A
Accessibility menu
S
Sheet menu
\\
Context menu

Formulas

~
Show all formulas
Insert array formulas
E
Collapse an expanded array formula
Fn
F1
Show/hide formula help