Google Sheets (Mac)

Common actions

Fill right

⌘ Cmd + R

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


Dashlane
Refresh / Sync
Application (Mac)

⌘ Cmd + R


Coda for iOS
Reload (preview only)
General

⌘ Cmd + R


DaVinci Resolve 15 (Mac)
Retime controls
Clip

⌘ Cmd + R


Ableton Live 10 (Mac)
Rename Selected Track
Commands for Tracks

⌘ Cmd + R


Tableau (Mac)
Refresh the data source
Data (Tableau Desktop)

⌘ Cmd + R


Cisco Jabber (Mac)
Redial
Call

⌘ Cmd + R


GeoGebra
Recompute all objects (including random numbers)
Mac desktop

⌘ Cmd + R


Cisco Webex
Lock the meeting
Mac

⌘ Cmd + R


TextMate
Refresh browser
HTML

⌘ Cmd + R


Sketch
Rename layer
Arranging layers

⌘ Cmd + R


Final Cut Pro X
Show or hide the retime editor
Effects

⌘ Cmd + R


QuickBooks Desktop (Mac)
Edit > Use Register
Editing

⌘ Cmd + R


Adobe Lightroom Classic (Mac)
Reload web gallery
Working in the Web module

⌘ Cmd + R


Adobe Bridge CC (Mac)
Open in camera raw
File menu

⌘ Cmd + R


Airmail
Reply
General

⌘ Cmd + R


Kindle for Mac
Go: Sync to furthest page read
Apple menu systems

⌘ Cmd + R


Adobe Animate CC (Mac)
Import image, sound, etc.
File

⌘ Cmd + R


Adobe Premiere Pro (Mac)
Speed/Duration...
Clip

⌘ Cmd + R


Corel Painter (Mac)
Show/Hide rulers
Canvas menu

⌘ Cmd + R


Adobe XD (Mac)
Make Repeat Grid
Object menu

⌘ Cmd + R


IntelliJ IDEA (macOS)
Run
Compile and run

⌘ Cmd + R


Apple Messages
Go to a chat room
Messages

⌘ Cmd + R


Adobe Audition (Mac)
Repeat previous command (opening its dialog box but not clicking OK)
Editing audio files

⌘ Cmd + R


Apple iBooks
Show the document rulers
General

⌘ Cmd + R


iPad Smart Keyboard
Show/Hide ruler
Pages

⌘ Cmd + R


Pocket for Mac
Refresh
File Menu

⌘ Cmd + R


Apple Finder
Show original for selected alias
File and window related

⌘ Cmd + R


Git Tower (Mac)
Refresh / reload data
General

⌘ Cmd + R


Apple Calendar
Refresh all calendars
Calendar shortcuts

⌘ Cmd + R


Apple Pages
Show or hide the ruler
General

⌘ Cmd + R


Xcode
Run
Product menu

⌘ Cmd + R


Apple macOS
Show the original file for the selected alias
Finder

⌘ Cmd + R


iTunes 11 for Mac
Check for app updates (when Apps is selected, below the Library)
iTunes Store

⌘ Cmd + R


Skype
Refresh the app
New Skype shortcuts (Mac)

⌘ Cmd + R


Final Draft 11 (Mac)
Reformat
Cmd key

⌘ Cmd + R