Google Sheets (Mac)

Open a menu

Data menu

Ctrl + ⌥ Option + D

All hotkeys for Google Sheets (Mac)

Common actions
Select column

Ctrl + Space

Common actions
Select row

↑   Shift + Space

Common actions
Select all

⌘ Cmd + A

Common actions
%%  Select all

⌘ Cmd + ↑   Shift + Space

Common actions
Undo

⌘ Cmd + Z

Common actions
Redo

⌘ Cmd + Y

Common actions
Redo

⌘ Cmd + ↑   Shift + Z

Use formulas
(when entering a formula) Absolute/relative references

Fn + F4

Common actions
Find

⌘ Cmd + F

Common actions
Find and replace

⌘ Cmd + ↑   Shift + H

Common actions
Fill range

⌘ Cmd + ⤶ Enter

Common actions
Fill down

⌘ Cmd + D

Common actions
Fill right

⌘ Cmd + R

Common actions
Save (every change is saved automatically in Drive)

⌘ Cmd + S

Common actions
Open

⌘ Cmd + O

Common actions
Print

⌘ Cmd + P

Common actions
Copy

⌘ Cmd + C

Common actions
Cut

⌘ Cmd + X

Common actions
Paste

⌘ Cmd + V

Common actions
Paste values only

⌘ Cmd + ↑   Shift + V

Common actions
Show common keyboard shortcuts

⌘ Cmd + /

Common actions
Compact controls

Ctrl + ↑   Shift + F

Common actions
Input tools on/off  (available in spreadsheets in non-Latin languages)

⌘ Cmd + ↑   Shift + K

Common actions
Select input tools

⌘ Cmd + ⌥ Option + ↑   Shift + K

Format cells
Bold

⌘ Cmd + B

Format cells
Underline

⌘ Cmd + U

Format cells
Italic

⌘ Cmd + İ

Format cells
Strikethrough

⌥ Option + ↑   Shift + 5

Format cells
Center align

⌘ Cmd + ↑   Shift + E

Format cells
Left align

⌘ Cmd + ↑   Shift + L

Format cells
Right align

⌘ Cmd + ↑   Shift + R

Format cells
Apply top border

⌥ Option + ↑   Shift + 1

Format cells
Apply right border

⌥ Option + ↑   Shift + 2

Format cells
Apply bottom border

⌥ Option + ↑   Shift + 3

Format cells
Apply left border

⌥ Option + ↑   Shift + 4

Format cells
Remove borders

⌥ Option + ↑   Shift + 6

Format cells
Apply outer border

⌥ Option + ↑   Shift + 7

Format cells
Apply outer border

⌘ Cmd + ↑   Shift + 7

Format cells
Insert link

⌘ Cmd + K

Format cells
Insert time

⌘ Cmd + ↑   Shift + ;

Format cells
Insert date

⌘ Cmd + ;

Format cells
Insert date and time

⌘ Cmd + ⌥ Option + ↑   Shift + ;

Format cells
Format as decimal

Ctrl + ↑   Shift + 1

Format cells
Format as time

Ctrl + ↑   Shift + 2

Format cells
Format as date

Ctrl + ↑   Shift + 3

Format cells
Format as currency

Ctrl + ↑   Shift + 4

Format cells
Format as percentage

Ctrl + ↑   Shift + 5

Format cells
Format as exponent

Ctrl + ↑   Shift + 6

Format cells
Clear formatting

⌘ Cmd + \

Navigate spreadsheet
Move to beginning of row

Fn +

Navigate spreadsheet
Move to beginning of sheet

⌘ Cmd + Fn +

Navigate spreadsheet
Move to end of row

Fn +

Navigate spreadsheet
Move to end of sheet

⌘ Cmd + Fn +

Navigate spreadsheet
Scroll to active cell

⌘ Cmd + ⬅ Backspace

Navigate spreadsheet
Move to next sheet

⌘ Cmd + ↑   Shift + Fn +

Navigate spreadsheet
Move to previous sheet

Ctrl + ↑   Shift + Fn +

Navigate spreadsheet
Display list of sheets

⌥ Option + ↑   Shift + K

Navigate spreadsheet
Open hyperlink

⌥ Option + ⤶ Enter

Navigate spreadsheet
Open Explore

⌥ Option + ↑   Shift + X

Navigate spreadsheet
Move focus out of spreadsheet

Ctrl + ⌘ Cmd + ↑   Shift + M

Navigate spreadsheet
Move to quicksum (when a range of cells is selected)

⌥ Option + ↑   Shift + Q

Navigate spreadsheet
Move focus to popup (for links, bookmarks, and images)

Ctrl + ⌘ Cmd then E then P

Navigate spreadsheet
Open drop-down menu on filtered cell

Ctrl + ⌘ Cmd + R

Navigate spreadsheet
Open revision history

⌘ Cmd + ⌥ Option + ↑   Shift + H

Navigate spreadsheet
Close drawing editor

↑   Shift + Esc

Navigate spreadsheet
Close drawing editor

⌘ Cmd + Esc

Edit notes and comments
Insert/edit note

↑   Shift + F2

Edit notes and comments
Insert/edit comment

⌘ Cmd + ⌥ Option + M

Edit notes and comments
Open comment discussion thread

⌘ Cmd + ⌥ Option + ↑   Shift + A

Edit notes and comments
Enter current comment

Ctrl + ⌘ Cmd then E then C

Edit notes and comments
Move to next comment

Ctrl + ⌘ Cmd then N then C

Edit notes and comments
Move to previous comment

Ctrl + ⌘ Cmd then P then C

Open a menu
File menu

Ctrl + ⌥ Option + F

Open a menu
Edit menu

Ctrl + ⌥ Option + E

Open a menu
View menu

Ctrl + ⌥ Option + V

Open a menu
Insert menu

Ctrl + ⌥ Option + I

Open a menu
Format menu

Ctrl + ⌥ Option + O

Open a menu
Data menu

Ctrl + ⌥ Option + D

Open a menu
Tools menu

Ctrl + ⌥ Option + T

Insert, delete, hide, or unhide rows or columns
(with columns selected) Insert columns to the left

⌘ Cmd + ⌥ Option + =

Insert, delete, hide, or unhide rows or columns
(with rows selected) Delete rows

⌘ Cmd + ⌥ Option + -

Open a menu
Form menu

Ctrl + ⌥ Option + M

Open a menu
Add-ons menu

Ctrl + ⌥ Option + N

Open a menu
(in Google Chrome) Help menu

Alt + H

Open a menu
(in other browsers) Help menu

Alt + ↑   Shift + H

Open a menu
(present when screen reader support is enabled) Accessibility menu

Ctrl + ⌥ Option + A

Open a menu
Sheet menu (copy, delete, and other sheet actions)

⌥ Option + ↑   Shift + S

Open a menu
Context menu

⌘ Cmd + ↑   Shift + \

Insert, delete, hide, or unhide rows or columns
(with rows selected) Insert rows above

Ctrl + ⌥ Option + I then R

Insert, delete, hide, or unhide rows or columns
Insert rows below

Ctrl + ⌥ Option + I then B

Insert, delete, hide, or unhide rows or columns
(with columns selected) Insert columns to the left

Ctrl + ⌥ Option + I then C

Insert, delete, hide, or unhide rows or columns
Insert columns to the right

Ctrl + ⌥ Option + I then O

Insert, delete, hide, or unhide rows or columns
(with rows selected) Delete rows

Ctrl + ⌥ Option + E then D

Insert, delete, hide, or unhide rows or columns
(with columns selected)  Delete columns

Ctrl + ⌥ Option + -

Insert, delete, hide, or unhide rows or columns
(with columns selected) Delete columns

Ctrl + ⌥ Option + E then E

Insert, delete, hide, or unhide rows or columns
Hide row

⌘ Cmd + ⌥ Option + 9

Insert, delete, hide, or unhide rows or columns
Hide column

⌘ Cmd + ⌥ Option + 0

Use formulas
Show all formulas

Ctrl + ~

Use formulas
Insert array formula

⌘ Cmd + ↑   Shift + ⤶ Enter

Use formulas
Collapse an expanded array formula

⌘ Cmd + E

Use formulas
(when entering a formula) Show/hide formula help

↑   Shift + Fn + F1

Use formulas
(when entering a formula) Full / compact formula help

Fn + F1

Use formulas
(when entering a formula) Toggle formula result previews

Fn + F9

Use formulas
Resize formula bar

Ctrl + ⌥ Option + ↑  ↓

Help for screen readers
Turn on screen reader support

⌘ Cmd + ⌥ Option + Z

Help for screen readers
Read column

⌘ Cmd + ⌥ Option + ↑   Shift + C

Help for screen readers
Read row

⌘ Cmd + ⌥ Option + ↑   Shift + R

Similar combinations for other applications


RStudio (Mac)
Diff active source document
Git / SVN

Ctrl + ⌥ Option + D