https://hkeys.app

Google Sheets Keyboard Shortcuts for macOS

Keyboard shortcuts for Google Sheets on Mac. Navigate cells, build formulas, and manage spreadsheet data on macOS.
Show table of contentsPrint shortcutsSign in to download the PDF It takes a few seconds.
Sign in → Sign in to save this shortcuts set to favorites.
Sign in →
Key label style

Common actions

Select column
Ctrl+Space
Select row
Shift+Space
Select all
Cmd+A
or
Cmd+Shift+Space
Undo
Cmd+Z
Redo
Cmd+Y
or
Cmd+Shift+Z
or
Fn+F4
Find
Cmd+F
Find and replace
Cmd+Shift+H
Fill range
Cmd+Return
Fill down
Cmd+D
Fill right
Cmd+R
Save (every change is saved automatically in Drive)
Cmd+S
Open
Cmd+O
Print
Cmd+P
Copy
Cmd+C
Cut
Cmd+X
Paste
Cmd+V
Paste values only
Cmd+Shift+V
Show common keyboard shortcuts
Cmd+/
Insert new sheet
Shift+Fn+F11
Compact controls
Ctrl+Shift+F
Input tools on/off (available in spreadsheets in non-Latin languages)
Cmd+Shift+K
Select input tools
Cmd+Opt+Shift+K
Tool finder (formerly Search the menus)
Opt+/
Select current region around selected cell
Cmd+Shift+8
or
Ctrl+Shift+8
Display or hide the menus
Cmd+Opt+R
or
Ctrl+Shift+F
Convert range to table
Cmd+Opt+T

Format cells

Bold
Cmd+B
or
Cmd+2
or
Ctrl+2
Underline
Cmd+U
or
Cmd+4
or
Ctrl+4
Italic
Cmd+I
or
Cmd+3
or
Ctrl+3
Strikethrough
Cmd+Shift+X
or
Cmd+5
or
Ctrl+5
Centre align
Cmd+Shift+E
Left align
Cmd+Shift+L
Right align
Cmd+Shift+R
Apply top border
Opt+Shift+1
Apply right border
Opt+Shift+2
Apply bottom border
Opt+Shift+3
Apply left border
Opt+Shift+4
Remove borders
Opt+Shift+6
Apply outer border
Opt+Shift+7
or
Cmd+Shift+7
or
Ctrl+Shift+7
Insert link
Cmd+K
Insert time
Cmd+Shift+;
Insert date
Cmd+;
Insert date and time
Cmd+Opt+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
Cmd+\

Navigate spreadsheet

Move to beginning of row
Fn+Left
Move to beginning of sheet
Cmd+Fn+Left
Move to end of row
Fn+Right
Move to end of sheet
Cmd+Fn+Right
Scroll to active cell
Cmd+Del
Move to next sheet
Opt+Down
or
Opt+Right
Move to previous sheet
Opt+Up
or
Opt+Left
Display list of sheets
Opt+Shift+K
Open hyperlink
Opt+Return
Open Explore
Cmd+Opt+Shift+I
Go to side panel
Cmd+Opt+.
or
Cmd+Opt+,
Move focus out of spreadsheet
Cmd+Ctrl+Shift+M
Move to quicksum (when a range of cells is selected)
Opt+Shift+Q
Move focus to pop-up (for links, bookmarks and images)
Cmd+Ctrl+E,Cmd+Ctrl+P
Open drop-down menu on filtered cell
Cmd+Ctrl+R
Open revision history
Cmd+Opt+Shift+H
Close drawing editor
Cmd+Esc
or
Shift+Esc
Show 'Go to range' dialogue
Ctrl+G
Find and replace with Find tab selected
Ctrl+F

Edit notes and comments

Insert/edit note
Shift+F2
Insert/edit comment
Cmd+Opt+M
Open comment discussion thread
Cmd+Opt+Shift+A
Enter current comment
Cmd+Ctrl+E,Cmd+Ctrl+C
Move to next comment
Cmd+Ctrl+N,Cmd+Ctrl+C
Move to previous comment
Cmd+Ctrl+P,Cmd+Ctrl+C

Use keyboard shortcuts on selected comments

Reply to current comment
R
Move to next comment
J
Move to previous comment
K
Resolve current comment
E
Exit current comment
U

Open a menu

File menu
Ctrl+Opt+F
Edit menu
Ctrl+Opt+E
View menu
Ctrl+Opt+V
Insert menu
Ctrl+Opt+I
Format menu
Ctrl+Opt+O
Data menu
Ctrl+Opt+D
Tools menu
Ctrl+Opt+T
Open insert menu (with cells selected)
Cmd+Opt+=
Open delete menu (with cells selected)
Cmd+Opt+-
Form menu (present when the spreadsheet is connected to a form)
Ctrl+Opt+M
Add-ons menu
Ctrl+Opt+N
Help menu
Ctrl+Opt+H
Accessibility menu (present when screen reader support is enabled)
Ctrl+Opt+A
Sheet menu (copy, delete and other sheet actions)
Opt+Shift+S
Context menu
Cmd+Shift+\
or
Shift+F10
Table column menu
Cmd+Opt+\

Add or change rows and columns

Insert rows above (with rows selected)
Cmd+Opt+=
or
Ctrl+Opt+I,R,R
Insert rows below
Ctrl+Opt+I,R,B
Insert columns to the left (with columns selected)
Cmd+Opt+=
or
Ctrl+Opt+I,C,C
Insert columns to the right
Ctrl+Opt+I,C,O
Delete rows (with rows selected)
Cmd+Opt+-
or
Ctrl+Opt+E,D,D
Delete columns (with columns selected)
Cmd+Opt+-
or
Ctrl+Opt+E,D,E
Hide row
Cmd+Opt+9
Unhide row
Cmd+Shift+9
Hide column
Cmd+Opt+0
Unhide column
Cmd+Shift+0
Group rows or columns
Opt+Shift+Right
Ungroup rows or columns
Opt+Shift+Left
Expand grouped rows or columns
Opt+Shift+Down
Collapse grouped rows or columns
Opt+Shift+Up

Use formulas

Show all formulas
Ctrl+`
Insert array formula
Cmd+Shift+Return
Collapse an expanded array formula
Cmd+E
Show/hide formula help (when entering a formula)
Shift+Fn+F1
Full/compact formula help (when entering a formula)
Fn+F1
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+Opt+Up
or
Ctrl+Opt+Down
Toggle formula range selection (when entering a formula)
F2
or
Ctrl+E

Help for screen readers

Turn on screen reader support
Cmd+Opt+Z
Enable braille support
Cmd+Opt+H
Read column
Cmd+Opt+Shift+C
Read row
Cmd+Opt+Shift+R

Need more than shortcuts?
Visit the Google Sheets app page for an overview and helpful links.

Want to suggest a new app, report a bug, or get help? Email us at info@hkeys.appCopy email.

For anything else or just a quick hello, write to us at info@hkeys.appCopy email.