Google Sheets (Mac) keyboard shortcuts

Google Sheets (Mac)

Zeynel Abidin Öztürk -
19 months ago
- Shortcuts

Frequent Google Sheets users will want to use some shortcuts, because they're quite powerful.

Ctrl + Space

Select column

↑   Shift + Space

Select row

⌘ Cmd + A

Select all

or ⌘ Cmd + ↑   Shift + Space
⌘ Cmd + Z

Undo

⌘ Cmd + Y

Redo

or ⌘ Cmd + ↑   Shift + Z
or Fn + F4
⌘ Cmd + F

Find

⌘ Cmd + ↑   Shift + H

Find and replace

⌘ Cmd + ⤶ Enter

Fill range

⌘ Cmd + D

Fill down

⌘ Cmd + R

Fill right

⌘ Cmd + S

Save (every change is saved automatically in Drive)

⌘ Cmd + O

Open

⌘ Cmd + P

Print

⌘ Cmd + C

Copy

⌘ Cmd + X

Cut

⌘ Cmd + V

Paste

⌘ Cmd + ↑   Shift + V

Paste values only

⌘ Cmd + /

Show common keyboard shortcuts

Ctrl + ↑   Shift + F

Compact controls

⌘ Cmd + ↑   Shift + K

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

⌘ Cmd + ⌥ Option + ↑   Shift + K

Select input tools

Fn +

Move to beginning of row

⌘ Cmd + Fn +

Move to beginning of sheet

Fn +

Move to end of row

⌘ Cmd + Fn +

Move to end of sheet

⌘ Cmd + ⬅ Backspace

Scroll to active cell

⌘ Cmd + ↑   Shift + Fn +

Move to next sheet

Ctrl + ↑   Shift + Fn +

Move to previous sheet

⌥ Option + ↑   Shift + K

Display list of sheets

⌥ Option + ⤶ Enter

Open hyperlink

⌥ Option + ↑   Shift + X

Open Explore

Ctrl + ⌘ Cmd + ↑   Shift + M

Move focus out of spreadsheet

⌥ Option + ↑   Shift + Q

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

Ctrl + ⌘ Cmd then E then P

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

Ctrl + ⌘ Cmd + R

Open drop-down menu on filtered cell

⌘ Cmd + ⌥ Option + ↑   Shift + H

Open revision history

↑   Shift + Esc

Open chat inside the spreadsheet

⌘ Cmd + Esc

Close drawing editor

or ↑   Shift + Esc
↑   Shift + F2

Insert/edit note

⌘ Cmd + ⌥ Option + M

Insert/edit comment

⌘ Cmd + ⌥ Option + ↑   Shift + A

Open comment discussion thread

Ctrl + ⌘ Cmd then E then C

Enter current comment

Ctrl + ⌘ Cmd then N then C

Move to next comment

Ctrl + ⌘ Cmd then P then C

Move to previous comment

Ctrl + ⌥ Option + F

File menu

Ctrl + ⌥ Option + E

Edit menu

Ctrl + ⌥ Option + V

View menu

Ctrl + ⌥ Option + I

Insert menu

Ctrl + ⌥ Option + O

Format menu

Ctrl + ⌥ Option + D

Data menu

Ctrl + ⌥ Option + T

Tools menu

⌘ Cmd + ⌥ Option + =

(with cells selected) Open insert menu

⌘ Cmd + ⌥ Option + -

(with cells selected)  Open delete menu

Ctrl + ⌥ Option + M

Form menu

Ctrl + ⌥ Option + N

Add-ons menu

Alt + H

(in Google Chrome) Help menu

Alt + ↑   Shift + H

(in other browsers) Help menu

Ctrl + ⌥ Option + A

Accessibility menu

Ctrl + ⌥ Option + A

(present when screen reader support is enabled) Accessibility menu

⌥ Option + ↑   Shift + S

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

⌘ Cmd + ↑   Shift + \

Context menu

⌘ Cmd + ⌥ Option + =

(with rows selected) Insert rows above

or Ctrl + ⌥ Option + I then R
Ctrl + ⌥ Option + I then B

Insert rows below

⌘ Cmd + ⌥ Option + =

(with columns selected) Insert columns to the left

or Ctrl + ⌥ Option + I then C
Ctrl + ⌥ Option + I then O

Insert columns to the right

⌘ Cmd + ⌥ Option + -

(with rows selected) Delete rows

or Ctrl + ⌥ Option + E then D
or ⌘ Cmd + ⌥ Option + -
or Ctrl + ⌥ Option + E then D
Ctrl + ⌥ Option + -

(with columns selected)  Delete columns

Ctrl + ⌥ Option + E then E

(with columns selected) Delete columns

⌘ Cmd + ⌥ Option + 9

Hide row

⌘ Cmd + ⌥ Option + 0

Hide column

Ctrl + ~

Show all formulas

⌘ Cmd + ↑   Shift + ⤶ Enter

Insert array formula

⌘ Cmd + E

Collapse an expanded array formula

↑   Shift + Fn + F1

(when entering a formula) Show/hide formula help

Fn + F1

(when entering a formula) Full / compact formula help

Fn + F4

(when entering a formula) Absolute/relative references

Fn + F9

(when entering a formula) Toggle formula result previews

Ctrl + ⌥ Option + ↑  ↓

Resize formula bar


Share this page on:

Program information

Program name: Google Sheets (Mac) Google Sheets (Mac) (Productivity)

Google Sheets is a spreadsheet program developed by Google. Its offered in Google Drive service, together with Docs and Slides. Sheets allows users to create and edit files online while collaboration with other users in real time.

Web page: https://www.google.com/sheets

Shortcut count: 115

How easy to press shortcuts: 68%

Similar programs


  1. Grand Theft Auto VGrand Theft Auto V
    67594   
  2. Keyboard symbolsKeyboard symbols
    52722    1
  3. Apex Legends (PC)Apex Legends (PC)
    40363   
  4. The Sims 4The Sims 4
    39097    3
  5. PlayerUnknown's BattlegroundsPlayerUnknown's Battleg
    35659    2
  6. DiscordDiscord
    34956   
More keyboard shortcuts...

Advertisement

Join our mailing list!

Your email is kept private and we don't spam.