https://hkeys.app

Google Sheets Keyboard Shortcuts for Mac

Keyboard shortcuts for Google Sheets on Mac. Move around cells, build formulas, format cells, add or change rows and columns, and work with comments.
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

Intro

Google Sheets on Mac runs in the browser, Chrome, Firefox, Edge, or Safari. There is no separate native Mac app. The shortcut set uses Command (⌘) as its primary modifier, consistent with macOS conventions throughout. Cmd+/ opens Google Sheets' built-in shortcut reference panel from inside any spreadsheet.

Mac-specific shortcut notes

Built-in shortcut list. Cmd+/ opens Google Sheets' own keyboard shortcut panel. Searchable and organized by category, particularly useful for finding formula shortcuts or less-common formatting combinations without leaving the spreadsheet.

Data range navigation. Cmd+Arrow moves the cursor to the last filled cell in the arrow's direction within a data range. In a large spreadsheet, Cmd+Down jumps from the current cell to the bottom of a contiguous column of data in one keystroke. This is the same behavior as Excel on Mac (also Cmd+Arrow) and one of the highest-value shortcuts for anyone working with real data.

Selecting data ranges. Cmd+Shift+Arrow extends the selection to the edge of the current data range. Combined with Cmd+Shift+End to select to the last cell with data, these are the selection shortcuts that make large-range operations practical without a mouse.

Formula entry on Mac. Entering edit mode in a cell, navigating within the formula bar, and confirming or canceling a formula entry all have Command-based shortcuts on Mac. The exact shortcuts are in the table.

Paste values only. Pasting without carrying over source formatting or formulas has a dedicated shortcut, useful when you want the numbers but not the formatting from a copied range. Covered in the table above.

Browser shortcut conflicts. A small number of Command combinations may be captured by the browser before Sheets sees them. The table above notes the most relevant cases.

Printable PDF

The Google Sheets macOS shortcut list is available as a printable PDF. The cell navigation and selection sections are the most useful for spreadsheet work with real data.

FAQ

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

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