Google Sheets (Mac) keyboard shortcuts

Google Sheets (Mac)  

Zeynel Abidin Öztürk -
3 years ago
- Shortcuts

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

0
Ctrl + Space

Select column

0
↑   Shift + Space

Select row

0
⌘ Cmd + A

Select all

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

Undo

0
⌘ Cmd + Y

Redo

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

Find

0
⌘ Cmd + ↑   Shift + H

Find and replace

0
⌘ Cmd + • Enter

Fill range

0
⌘ Cmd + D

Fill down

0
⌘ Cmd + R

Fill right

0
⌘ Cmd + S

Save (every change is saved automatically in Drive)

0
⌘ Cmd + O

Open

0
⌘ Cmd + P

Print

0
⌘ Cmd + C

Copy

0
⌘ Cmd + X

Cut

0
⌘ Cmd + V

Paste

0
⌘ Cmd + ↑   Shift + V

Paste values only

-1
⌘ Cmd + /

Show common keyboard shortcuts

0
Ctrl + ↑   Shift + F

Compact controls

0
⌘ Cmd + ↑   Shift + K

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

0
⌘ Cmd + βŒ₯ Option + ↑   Shift + K

Select input tools

0
Fn + ←

Move to beginning of row

0
⌘ Cmd + Fn + ←

Move to beginning of sheet

0
Fn + β†’

Move to end of row

0
⌘ Cmd + Fn + β†’

Move to end of sheet

0
⌘ Cmd + β¬… Backspace

Scroll to active cell

0
⌘ Cmd + ↑   Shift + Fn + ↓

Move to next sheet

0
Ctrl + ↑   Shift + Fn + ↑

Move to previous sheet

0
βŒ₯ Option + ↑   Shift + K

Display list of sheets

0
βŒ₯ Option + • Enter

Open hyperlink

0
βŒ₯ Option + ↑   Shift + X

Open Explore

0
Ctrl + ⌘ Cmd + ↑   Shift + M

Move focus out of spreadsheet

0
βŒ₯ Option + ↑   Shift + Q

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

0
Ctrl + ⌘ Cmd then E then P

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

0
Ctrl + ⌘ Cmd + R

Open drop-down menu on filtered cell

0
⌘ Cmd + βŒ₯ Option + ↑   Shift + H

Open revision history

0
↑   Shift + Esc

Open chat inside the spreadsheet

0
⌘ Cmd + Esc

Close drawing editor

0
or ↑   Shift + Esc
0
↑   Shift + F2

Insert/edit note

0
⌘ Cmd + βŒ₯ Option + M

Insert/edit comment

0
⌘ Cmd + βŒ₯ Option + ↑   Shift + A

Open comment discussion thread

0
Ctrl + ⌘ Cmd then E then C

Enter current comment

0
Ctrl + ⌘ Cmd then N then C

Move to next comment

0
Ctrl + ⌘ Cmd then P then C

Move to previous comment

0
Ctrl + βŒ₯ Option + F

File menu

0
Ctrl + βŒ₯ Option + E

Edit menu

0
Ctrl + βŒ₯ Option + V

View menu

0
Ctrl + βŒ₯ Option + I

Insert menu

0
Ctrl + βŒ₯ Option + O

Format menu

0
Ctrl + βŒ₯ Option + D

Data menu

0
Ctrl + βŒ₯ Option + T

Tools menu

0
⌘ Cmd + βŒ₯ Option + =

(with cells selected) Open insert menu

0
⌘ Cmd + βŒ₯ Option + -

(with cells selected) Β Open delete menu

0
Ctrl + βŒ₯ Option + M

Form menu

0
Ctrl + βŒ₯ Option + N

Add-ons menu

0
Alt + H

(in Google Chrome) Help menu

0
Alt + ↑   Shift + H

(in other browsers) Help menu

0
Ctrl + βŒ₯ Option + A

Accessibility menu

0
Ctrl + βŒ₯ Option + A

(present when screen reader support is enabled) Accessibility menu

0
βŒ₯ Option + ↑   Shift + S

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

0
⌘ Cmd + ↑   Shift + \

Context menu

0
⌘ Cmd + βŒ₯ Option + =

(with rows selected) Insert rows above

0
or Ctrl + βŒ₯ Option + I then R
0
Ctrl + βŒ₯ Option + I then B

Insert rows below

0
⌘ Cmd + βŒ₯ Option + =

(with columns selected) Insert columns to the left

0
or Ctrl + βŒ₯ Option + I then C
0
Ctrl + βŒ₯ Option + I then O

Insert columns to the right

0
⌘ Cmd + βŒ₯ Option + -

(with rows selected) Delete rows

0
or Ctrl + βŒ₯ Option + E then D
0
or ⌘ Cmd + βŒ₯ Option + -
0
or Ctrl + βŒ₯ Option + E then D
0
Ctrl + βŒ₯ Option + -

(with columns selected) Β Delete columns

0
Ctrl + βŒ₯ Option + E then E

(with columns selected) Delete columns

0
⌘ Cmd + βŒ₯ Option + 9

Hide row

0
⌘ Cmd + βŒ₯ Option + 0

Hide column

0
Ctrl + ~

Show all formulas

0
⌘ Cmd + ↑   Shift + • Enter

Insert array formula

0
⌘ Cmd + E

Collapse an expanded array formula

0
↑   Shift + Fn + F1

(when entering a formula) Show/hide formula help

0
Fn + F1

(when entering a formula) Full / compact formula help

1
Fn + F4

(when entering a formula) Absolute/relative references

0
Fn + F9

(when entering a formula) Toggle formula result previews

0
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: google.com/sheets

Last update: 17 January 2020

How easy to press shortcuts: 67%

More information >>

Shortcut count: 115

Platform detected: Windows and macOS mixed

Similar programs



Advertisement

Join our mailing list!

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